suppressing spaces within a text box

[cathy]

i work in a high school in the Blue Mountains Australia.
For our school mail outs we have a separate text box for
house/PO Box numbers and a separated text box for Street
name. we import this data from an old non-windows program
which all schools in our state are labouring with. We have
to allow for the longer house/PO Box numbers but would
like not to have to have such a big space between
Street/PO box numbers and Street name:
ie 34 Smith St
This looks really unprofessional
is there any way to link the two text boxes and/or
suppress the spaces or blanks???

if you can help please email (e-mail address removed)

 

[Ken Snell]

Set the control source of a textbox to display the result to an expression
similar to this:

=Trim([StreetNumberField]) & " " & Trim([StreetNameField])