Hello
I hope someone can help, I would like to produce a letter in Access and as part of the letter I need to say [Forename]'s work has been very good etc - but I cannot work out how to remove the spaces if Forename is 5 or 20 characters, so the " 's work has been very good etc" does not line up well with forename.
Does anyone know how to do this please in Access 2010 ?
Thanks
Elaine