Field problem after converting from97 to 2000

[texasalynn]

Does any one know if there is an issue with Access 97 database created field lengths not converting in Access 2000?

I have a field that I created in Access 97:
Description: IIf(Left([Invoice History Detail]![HDCUNO],3)="001" And Left([Invoice History Detail]![HDSYCD],1)="1" Or (Left([Invoice History Detail]![HDCUNO],3)="002" And Left([HDSYCD],1)="7"),"RECYCLE","TRASH") & " " & [Invoice History Detail]![HDCTQT] & "-" & [Invoice History Detail]![HDCTSZ] & [Invoice History Detail]![HDVLCD] & " " & IIf([Invoice History Detail]![HDPUDY] Is Null Or Len([Invoice History Detail]![HDPUDY])-CharCount("-",[Invoice History Detail]![HDPUDY])=0,"ON CALL",Len([Invoice History Detail]![HDPUDY])-CharCount("-",[Invoice History Detail]![HDPUDY])) & "/W-" & Left([Invoice History Detail]![HDINVN],6)

But in Access 2000 it breaks. When I try to edit the field only part of it is shown. How do I fix? I'm thinking that it has too many characters so I will have to break it into two or more fields then create another query to add the two fields together. Does anyone have any ideas?

Thanks . . . texasalynn

 

[texasalynn]

Just thought I'd fill in the answer. Access has a limit in queries for individual fields of 512 characters. So that was the problem.

texasalynn