CODEWITHSUNDEEP
ms-access
BlackGaff
BlackGaff

Reputation: 7707

ACCESS - how to store single space as cell value

In Acess 2007, we need to store the value of "space" into a cell for testing purposes. For the life of me, I can't figure out how to do this. Any thoughts?

Upvotes: 3

Views: 885

Answers (1)

Conrad Frix
Conrad Frix

Reputation: 52645

You'll need to update the data from a query or through code because the datasheet view trims trailing spaces

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

then this will return results later.

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

Upvotes: 3

Related Questions