Maximum characters in a text box

[WalkieTalkie]

I have a report in Access 97. There is a text box on the report, that is bound to a field in a query. When I run the query, the field returns the results expected, but on the report it comes out with the last few characters missing. The text box is set to CanGrow = Yes, so that is not the problem. I can make the last few characters show if I delete the same number of characters at the beginning. In other words, it looks as if I have hit the maximum limit of characters for a text box. BUT the database specs for Access 97 say that the maximum is 65,535 characters! I have nowhere near that - I haven't counted, but I'd guess no more than 250.

Can anyone suggest what is going on?

 

[KenReay]

Hi

The maximum length of a string type is 255, the maximum length of a memo type is 65,535. Presumambly in the table the column is of type memo ?, are you doing something to it (for exampe formating it with FORMAT()), which converts it to a string type

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dhookom]

If you haven't applied any format, open the report's record source in datasheet view and see if all the characters are included in the query. If not, remove any syntax in the SQL like "GROUP BY", "DISTINCT",...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[WalkieTalkie]

Thanks, Ken. I hadn't appreciated the difference between a string type and memo type. It is a string, generated by an IIf expression. That explains it. And now I know how to fix it...

Thanks again - what a great site this is.

Cheers
Miranda