This is an EASY One for all you Experts

[Guest_imported]

Please help out this novice VBA user!!!!

We have an Access 97 SR-2 database that was transferred from another office. On all reports (invoices, POs, etc), the address is being pulled from a 'function call'. This 'function call' has a feild name (ie custName) then the code & LF then the next field name. What this returns is the feilds all 'bunched together' (i.e. Customer Name1234 Addams streetPheonix, AR. It seems that the & LF should be putting a carriage return in and it is not. Does anyone know of a better (ans extremely simple) way of getting our carraige returns back. PS: In my infinite wisdom, I tried replacing the LF with a CR. Didn't work. HELP!!

 

[JoeMiller]

Replace lf with

& Chr(13) & Chr(10) &

HTH Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

Or just vbCrLf
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over