Problem with Trim

[database]

Hi everyone,

I have a basic problem...

I am preparing labels which contain first name, lastname and address.
On the report design sheet, I have a textbox which says
=Trim([FirstName] & " " & [LastName])
it gives an error here.

Can anyone tell me what wrong that i am doin ?

thanks
dB

 

[WayneRyan]

Hi db,

You don't specify what the error is.

It looks like your syntax is OK. Are you sure that the
names of the fields are correct?

=Trim([FirstName] & " " & [LastName])

will collapse the middle space. Why are you using Trim?

Why not just make:

NewField: [FirstName] & " " & [LastName]?

I'd bet that your fields are really [First Name] and [Last Name].

Wayne

 

[database]

Hi db,

You don't specify what the error is.

It looks like your syntax is OK. Are you sure that the
names of the fields are correct?

=Trim([FirstName] & " " & [LastName])

will collapse the middle space. Why are you using Trim?

Why not just make:

NewField: [FirstName] & " " & [LastName]?

I'd bet that your fields are really [First Name] and [Last Name].

Wayne

Thanks wayne...

The name are very much correct... Also it does not give error when i run the report...it just shows # error instad of the first and last name in the print preview mode...

I will try without using trim

Thanks a lot
dB

 

[WayneRyan]

Database,

Wait a minute. If this is a report, is if fed by a query? If so,

NewField: [FirstName] & " " & [LastName]

Then just use Newfield in your report.

Wayne