Access textbox truncates characters

[TheWebDataGuy]

I have an access textbox displaying a sql server field (varchar, 8000). My problem is that the form would only show 4000 characters and truncate the rest. It saves all the comments but displays only 4000.

Any ideas?

Thanks,

 

[SteveR77]

I am going to assume that the text box field has been defined as a memo.

If you resize the control are you able to see any more of your data?



Steve

 

[TheWebDataGuy]

I am working on .adp with SQL Server back-end. Cannot define the field type in access. It is a varchar in sql server. Resizing doesn't help.

It surely has to be some access setting becoz I can see all the data in sql server.