Setting multi-line text field to have both scroll bars and no line wrap, how?

[mdlueck]

Access 2007 on Windows XP

I am not seeing a property setting to enable a horizontal scroll bar for a text field.

And also I need to disable the control from doing line wrap.

Basically I want Access to display the text as-is and do no reformatting.

I have set my font to a mono-space font, so that point is successfully covered.

Suggestions please? Thanks!

 

[bob fitz]

I don't know about A2007 but in A2003 there is no property setting to enable a horizontal scroll bar for a text field.

And also I need to disable the control from doing line wrap.

If you set the Scroll Bars property to "None" does it not then behave as required?

 

[missinglinq]

As Bob has said, there are no Horizontal Scrollbars for Textboxes in Access Forms. As to your requirement for no word wrapping, AFAIK, the only thing you can do to enforce this is to make sure that your Textbox is wide enough to hold the data. Using your monospace font, you could probably use the OnChange event of the Textbox to adjust its width while entering data./ You'd also have to do the same thing in the OnCurrent event of the Form, and you could only do this in a Single View Form.

What exactly is your business requirement, here, for not wanting the data to wrap?

Linq ;0)>

 

[mdlueck]

This is to display Build Of Material (BOM) text files coming from other systems.

Each line is a part within the product.

I was thinking to have the two BOM fields side-by-side with scroll bars. Clearly that is not going to be possible.

So "one on top of the other" is my present plan.

missinglinq: These are read-only fields. How can I tell if the control was wide enough such that no lines ended up wrapping?

Thanks!

 

[missinglinq]

Actually Stephen Lebans, the Wizard of New Brunswick, has a hack for giving 'CanGrow/CanShrink' capability to Forms, similar to those functions in Reports:

http://www.lebans.com/cangrow.htm

I've never used it, but Lebans little gems are always spot on!

Linq ;0)>