Limit Text Box to only Accept one line of text

[Addammer]

I assume this is an easy fix.

How do I limit a text box to only allow one line of text? If I keep
typing it will wordwrap, but then when I open a report everything that
isn't on that list is not included.

Thanks,
Adam

 

[Rick Brandt]

I assume this is an easy fix.

How do I limit a text box to only allow one line of text? If I keep
typing it will wordwrap, but then when I open a report everything that
isn't on that list is not included.

Set the CanGrow property of the TextBoxes on the report to Yes. Then they will
expand as necessary to show all of the text.

 

[tina]

well, you can set the FieldSize property for that field in the underlying
table, to "x" number of characters. the easiest way to get a "good" limit is
to type something in the form's textbox and count the characters; don't
forget to take into account that some letters are "fatter" than others and
may take up more space, so you'll want to err on the side of "smaller"
rather than "bigger" when setting the property.

rather than doing the above, you can open the report in Design view, click
on the textbox control in question, and set its' CanGrow and CanShrink
properties to Yes. then click on the section of the report that the control
is in, and set the *section's* CanGrow and CanShrink properties to Yes. this
allows the control's vertical size to reset automatically to provide enough
room for the text in the underlying field, and no more.

hth