I would like to store a single whitespace at the end of a value in Access so that when I fetch it using VB, I get something like 'value '. How can I achieve this?
That would achieve the same end result, but I would like to be able to enter the entire string (including the trailing whitespace) in the database without Access trimming off the end white space chars.
Is there any way that you know of that would allow me to apply that to the physical field? I have tried entering "@@@" to the format for a field of length 3, but Access still trims the data as I enter it.
you can use it on the control where you capture the data... but for existing records, you can run an update query on the table (save a copy of it before you run the query).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.