Placing a Hard Return in a Text Box

[TJBernard]

I have a database in which the users have requested a "review screen". This form will not all edits/additions/deletions, it is built just to review data entered into the database.

Since this form does not contain any functionality, the users would like to see the name of the person set up like on an envelope. Like the following:

Joe A. Bread
1101 State Street
Apt 9
Anytown, Kansas 66000

I was trying to use the chr(13) and chr(10) function, but instead of inserting a hard return, these functions just inserted a box looking character.

If anyone has any ideas let me know.

Thank you for your time,

T.J.

 

[Mile-O]

Build a string from the details you have using the vbCrLF constant and display it in the textbox.

 

[Rich]

=[Company Name] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] & Chr(13) & Chr(10) & [PostalCode]