|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 7th, 2009, 04:44 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Mailing address
I have the following text box on a report:
=Trim([titles] & " " & [firstname]) & " " & [lastname] & Chr(13) & Chr(10) & Trim([unit/flat] & " " & [unit/flat no] & Chr(13) & Chr(10) & "" & ([street number] & "" & [street prefix] & " " & [street name]) & Chr(13) & Chr(10) & Trim([suburb] & " " & [state] & " " & [pcode])) What I would like is when there is no Unit/Flat in the address, then this line space will close up. Could someone kindly advise how this can be achieved? Many Thanks 
|
|
#2
February 11th, 2009, 02:52 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Mailing address
This should get rid of the extra line:
=Trim([titles] & " " & [firstname]) & " " & [lastname] & Chr(13) & Chr(10) & Iif(not isnull([unitflat]),Trim([unit/flat] & " " & [unit/flat no]) & Chr(13) & Chr(10),"") & ([street number] & "" & [street prefix] & " " & [street name]) & Chr(13) & Chr(10) & Trim([suburb] & " " & [state] & " " & [pcode])) Roger Bell wrote: I have the following text box on a report: =Trim([titles] & " " & [firstname]) & " " & [lastname] & Chr(13) & Chr(10) & Trim([unit/flat] & " " & [unit/flat no] & Chr(13) & Chr(10) & "" & ([street number] & "" & [street prefix] & " " & [street name]) & Chr(13) & Chr(10) & Trim([suburb] & " " & [state] & " " & [pcode])) What I would like is when there is no Unit/Flat in the address, then this line space will close up. Could someone kindly advise how this can be achieved? Many Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200902/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
