Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion



By pina ·
I have on a report, name and surname fields to be printed on the address area.
I would like to organise these two fields in such a way that the name and surname are at the same distance whatever the size of the name or surname is. e.g. a long surname will fit in the field without overlapping on the name field.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to MS-Access

check out the TRIM function

Collapse -

by timfox In reply to MS-Access

Joining the FirstName and Surname fields within your query will give you one value to display rather than two. This can easily be done with the Build button (available by right-clicking the Field value in the query design window).

Name: [Table1]![FirstName] & " " & [Table1]![Surname]

Collapse -

by pina In reply to

Poster rated this answer.

Collapse -

by pina In reply to MS-Access

This question was closed by the author

Related Discussions

Related Forums