How to put single space in field?

[jlthomas2]

I need to put a single space in a field in Access 2007 in order to link
appropriately to other tables. When I do a single space, it takes the space
out and the field is just null (and null does not link to the other table).
With Access 2003 I could make a single space in Excel and copy that over, but
the same trick does not work with 2007. Any help?

 

[Beetle]

Check the Allow Zero Length property of that field. I believe it defaults
to No in A2007 (in A2003 the default was Yes).

 

[david]

A button on the form with code like this:
me!myboundfield = " "

Are you using an MDB data file or an ACDB?

SQL Server text fields normally do NOT allow the data to
be a single space, so if you cross-grade to a SQL Server back
end, you have more work in front of you.

Access forms normally truncate trailing spaces, so it is difficult
to get trailing spaces into a table, but MDB tables do accept the
spaces if you paste them in or use code. SQL Server varchar
fields don't normally accept spaces like that at all. ACDB tables
I haven't tried.

(david)