I am trying to combine a TRIM and REPLACE before my field name in a RECORD SOURCE so it trims the leading and trailing spaces, and also removes and occurrence of Double Spaces.
Anyone suggest how I can do this ?
many many thanks
Colin....
Novice
Windows 7 64bit 
Access 2013
I am trying to combine a TRIM and REPLACE before my field name in a RECORD SOURCE so it trims the leading and trailing spaces, and also removes and occurrence of Double Spaces.
Anyone suggest how I can do this ?
many many thanks
Colin....
Novice
Windows 7 64bit Access 2013
Should have said, its the combining of the two that causing me problems, I can create one or the other at the moment...
VIP
Windows XP Access 2007
Can you post the two individual formulas you have that work on each piece, and we'll see if we can help you combine them?
Control source Expression giving #Error
What is the difference between a Record Source and a Control Source?
Textbox Control Source As An Expression help!
Posting Permissions
Reply With Quote