ACCESS - How to store a single space as a cell value

Question

In Acess 2007, we need to store the value "space" in the cell for testing purposes. For my life, I cannot figure out how to do this. Any thoughts?

Answer 1

You will need to update the data from the query or through code, because the presentation of the data table truncates trailing spaces

   UPDATE Table1 SET Table1.Foo = " "
   WHERE (((Table1.ID)=1));

then it will return the results later.

SELECT Table1.ID, Table1.Foo
FROM Table1
WHERE (((Table1.Foo)=" "));