>>254 limit ? You mean for portion displayed in combo or SQL itself. If latter then workaround is to make it a memo field.
>
>Seems to be in SQL itself as I get the "Line too long" error when combinied field length is 255, but not at 254. Can I create the memo field on the fly using the combined fields as I create the cursor in the RowSource?
You could Renoir but how would you do it display in combo ? I think then you would hit combo string limit.
IMHO show it partially in combo and mabybe beneath it in a label control caption build after selection.
Cetin