Display Full Name Other Way Round

[paulS30berks]

I have a field within a table entitled "Name Display" This displays names in the format:

Surname,forename

I have used the following:

Full Name: Right([Name_Display],Len([Name_Display])-InStr([Name_Display]," ")) & " " & Left([Name_Display],InStr([Name_Display]," ")-1)

To rearrange so format is displayed as forename,surname

However my output with some fields appears as:

SARAH WAILES, with spaces inbetween.

Can anyone suggest a way of removing these spaces?

Thanks

 

[neileg]

Use Trim()

It would have been more usual to hold the forename and surname as separate fields so you don't have to use string functions to chop them up.