Multiline in Access 2007? Need a line feed on a text box.

[dk4300]

I'm building a window to show a log at the completion of each process.
Ex "6/15/2011 8:27:56 PM IMPORT COMPLETE"
I need a line feed in my text box (so I can list them) and using Chr(13) returns the paragraph box but not the line feed. I've looked this up already and everywhere it says that you need to set the text box multiline property to true.
I'm in access 2007 and can't find it.
What am I missing?

[Stewart Ross]

You need to use a carriage return and line feed (Chr(13) and Chr(10)) together. If you are inserting your Chr(13) using the AfterUpdate event, say, then you can either add & Chr(10) to your current line, or, more simply, use the constant provided by VBA for this purpose to replace your Chr(13):

Me!YourTextBox = Me!YourTextBox & vbCrLf

to add a line space after the current line.

Please note that the vb constant is not available outside of the VBA environment (it cannot be used in expressions in the properties box of a control, for example).

The multi-line property you mention applies to data entry via the keyboard, not to display of existing text - textboxes will display multiple lines without further alteration to their properties as long as the lines are separated by true line breaks (CR & LF sequences).

-Stewart

[dk4300]

I had forgotten about the Chr(10) part, but I'll use the vbCrLf from now on.
Thank you!!