Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ignore Blank Fields When Concatenating

Status
Not open for further replies.
docar

docar

Technical User
Nov 20, 2002
12
US
I'm concatenating 3 fields like this:

FullName: [LNAME] & " " & [MNAME] & " " & [FNAME]

If the MNAME field is blank, then there are 2 blank spaces in between LNAME and FNAME.

How can I get rid of this extra blank space?

Thanks in advance.
 
Sort by date Sort by votes
Try replacing one of the ampersands (&) with pluss (+):

[tt]FullName: [LNAME] & " " + [MNAME] & " " & [FNAME][/tt]

Roy-Vidar
 
Upvote 0 Downvote
Beautiful! Thanks a lot Royvidar!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
300
atadbitslow
atadbitslow
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
148
v5652
v5652
Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
129
Jaime_78
Jaime_78
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
110
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
You must use the dbSeeChanges opion with OpenRecordset when accessing a SQL Server table
Replies
9
Views
229
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top