adress field

[News]

I have on a form the following fields: Adress, Number, Postal Code, Place,
and Country. When I change one of those fields, I want to change the field
AdressField also.
On the AdressField the adress is shown with linebreaks.

For instance if Adress = "Raadhuislaan", Number = "1", Postal Code = "2651
DA", and Place = "Berkel en Rodenrijs", then AdressField =
"Raadhuislaan 1
2651 DA Berkel en Rodenrijs".

For the linebreak I used chr(13), chr(10), chr(11), but in the AdressField,
the postcal code does not start on a new line.
In stead, there is e non-readable character and then the postal code follows
on the same line.
What am I doing wrong?

Lodewijk

 

[Wayne Phillips]

The line break you should be using is both Chr(13) & Chr(10).

Regards,

Wayne Phillips
http://www.everythingaccess.com

 

[Bob Hughes]

Or you could use
vbCrLf

Bob

 

[Wayne Phillips]

Or you could use
vbCrLf

Bob

Not from within a form/report you can't... only from within VBA code.

Wayne Phillips
http://www.everythingaccess.com