Question spacing issue

[hayden]

i know this breaks first normalisation but on my report i have surname and forename together so you get the name and everything else looking like an address etc
John smith
123 grant lane
Manchester

but my isssue is that i have to leave big enogh space for large first names
like Alexandra rather than Sam and get big gap for the smaller names
e.g.
Alexandra Burke
Sam Burke

is there a way of merging fields or making it auto adjust etc... if so how??

 

[SOS]

You can take individual fields and make up an address block easily with one text box:

=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] & ", " & [State/Region] & " " & [Post code]

Which then takes care of spacing for you.

 

[SOS]

That is - if you set the CAN GROW and CAN SHRINK properties of the control and the section it is in to YES.

 

[hayden]

=[FirstName] & " between these do i need to put anything" & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] & ", " & [State/Region] & " " & [Post code]

and does chr(10) mean the character length

 

[SOS]

=[FirstName] & " between these do i need to put anything" & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] & ", " & [State/Region] & " " & [Post code]

and does chr(10) mean the character length

Okay, for the part in red, I had a single space denoted by

" "

concatenated in - so

[FirstName] & " " & [LastName]

which has FirstName LastName with a space in between.

Chr(10) & Chr(13)

together form a Carriage Return and Line Feed. And they need to be used together and in that exact order.

 

[ghudson]

Chr(10) & Chr(13)

together form a Carriage Return and Line Feed. And they need to be used together and in that exact order.

Or use this to force data to the next line...

& vbCrLf &

 

[SOS]

Or use this to force data to the next line...

& vbCrLf &

Except you can't use vbCrLf in a control source (which is what I was showing).

 

[ghudson]

Except you can't use vbCrLf in a control source (which is what I was showing).

Oops, my bad.

 

[SOS]

Oops, my bad.

You're allowed - you rarely have any so at least it helps make you seem human