Preserve trailing space entered in text box

[rhg]

I am using a standard userform text box to display/enter data into an SQL db.
I'd like the user to be able to type text into the text box that includes a
single trailing space. Access seems to be trimming the trailing space before
I ever get to update the record in SQL. I can use the debugger and put the
space back in before saving to SQl and SQL preserves the space. So, it's not
SQL. Is there a text box property that is causing the access userform to
truncate this trailing space that I can reset?

 

[Allen Browne]

Yes, Access does trim trailing spaces before writing the value to the field.

You can assign a trailing space to a field programmatically, but AFAIK you
can't get a bound text box to write the trailing space.