Field Size and Conversion Problem

[judyscofield]

In an Access2000 app I have a create table query that uses First or Min options in the Totals line. This creates a table with a field size of 255 for those fields.

I need to convert this app backwards to Access97 as some users only have 97 on their machines. I get an error in the conversion that the field size is too long. The table is created new each time the app is run. How can a alter the field size in code after the table is created soit will convert?

 

[tlbroadbent]

Here is one way to alter the column size in code.

DoCmd.RunSQL("Alter Table TableName Alter ColName Text(40)&quot Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.