General discussion

Locked

MS-Access

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.

4 total posts (Page 1 of 1)  
| 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).

eg.
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

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums