address in header

[Guest]

I am struggling with Access 2007! Firstly, I am trying to form an invoice.
Whenever I try to type the address in the header, it will not let me put in a
'Return' to add subsequent lines.
Similarly, I have set up an expression in the body of the form to lay out an
address, but it is all one one line. How do I put a 'Return' in an expression?

 

[Guest]

In Access 2000,
In the "other" tab of the properties there is one called "enter key
behaviour" so you can put text on different lines (that is what your message
is implying)

 

[RBear3]

In your entry, I would suggest separate fields for each element...

Address1
Address2
City
State
ZIP



To build a properly constructed address in your reports:

= "This is line 1." & chr(13) & chr(10) & "This is line 2."

= "This is line 1." & vbcrlf & "This is line 2."

 

[RBear3]

Note also that if you don't want to skip a line when a field is blank
(addresses without an address2) you can do something like this...

= [Address1] & chr(13) & chr(10) & ([Address2] + chr(13) + chr(10)) & [City]
& ", " & [State] & " " & [ZIP]





The "+" will only include the items if they are not blank.

 

[Guest]

I will try that, but how do I get several (fixed) lines in header ie. my
name, address, telephone number etc?

Note also that if you don't want to skip a line when a field is blank
(addresses without an address2) you can do something like this...

= [Address1] & chr(13) & chr(10) & ([Address2] + chr(13) + chr(10)) & [City]
& ", " & [State] & " " & [ZIP]





The "+" will only include the items if they are not blank.








--
Hope that helps!

RBear3
..

I am struggling with Access 2007! Firstly, I am trying to form an invoice.
Whenever I try to type the address in the header, it will not let me put
in a
'Return' to add subsequent lines.
Similarly, I have set up an expression in the body of the form to lay out
an
address, but it is all one one line. How do I put a 'Return' in an
expression?