Trim Function

[pollypocket]

I have generated a report which i based on a query. The problem im having is

First name and last name fields.I want to trim blank space so for example Louise Wood looks as typed not Louise Wood. I know the trim function can do this but im not to sure where on the report to place it??!

Any ideas

 

[IMO]

I have generated a report which i based on a query. The problem im having is

First name and last name fields.I want to trim blank space so for example Louise Wood looks as typed not Louise Wood. I know the trim function can do this but im not to sure where on the report to place it??!

Any ideas

Not sure what you mean, do you want to separate the words a put them in individual fields?

IMO

 

[IMO]

You can place the following in an unbound text field to get the first name....

=Left([YourTextField],InStr([YourTextField]," "))

And

=Mid([YourTextField],InStr([YourTextField]," "))

to get the last Name.

IMO

 

[Pat Hartman]

Rather than binding each table field to its own control, create a calculated field in the query and bind that:

Select ...., FirstName & " " & LastName As FullName, ....