text boxes are truncating

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

I have a form with limited space. Most of the values in
the table are fairly short (20 or 30 chars) but some of
the values are very long (over 200 characters) and are
being truncated when displayed in a text box.

I can turn on scroll bars. However, the scroll bars only
appear when the user clicks in the text box, and they may
not realize that things are being truncated so they will
not click in the text box.

Is there any way to tell when a value is being truncated?
It has crossed my mind to display a subform with fewer
fields but more room for each when one or more fields is
being truncated. Is this possible?
 
You could use conditional formatting on the textbox that changes the
background color when the length of the text string exceeds a certain
number. Or you could size the textbox so that the user sees 1.5 lines of
text, showing that the text is not all visible.
 
I've had this happen when the format for a text box has been inadvertantly
set to "General Number" - it will truncate text and memo fields at 200 or so
characters, even though it appears they've been entered correctly and they
stay visible when entered, in the table they're truncated.
John
 
Back
Top