Text Box Truncating

[Daryl]

I have a text box that provides a brief description of a product. If the field has no value (null or ZLS) it is set to display "No Description Available". This works fine except when the field has data beyond so many characters. That is, you only see part of the description. The data is still in the table, but the user can't see it. Similarly, the truncation occurs when entering data in the text box.

How can I set the field to see the entire description and still be able to see "No Description Available" when there is no data to be viewed?

 

[LQ]

Uhhh...at the risk of sounding too simplistic, have you tried resizing the text box? The text that users are entering is not really being truncated (unless it's going over the 255 character limit for a text field), it is just being blocked from view by a too-small text box.

 

[Daryl]

That's the first thing I had thought. But, the size of the text box is adequate because I can see the entire description if I don't include the phrase "@;No Description Available" in the Format Property of the text box. The description text box relates to a memo field in the table, so the 255 character limitation is not the problem. I'm wondering if this is a Microsoft limitaion issue.

 

[Rich]

Surely you can't use the Format property, use VBA to enter "No Description Available" or the default value.

 

[Daryl]

In case anyone else encounters this problem, Microsoft Knowledge Base article Q103998 confirmed my suspicions. I'll just have to wait until the company upgrades my Access 97 software.