I'm doing automated testing. I have a script that contains the flow (which screens have to be opened, ...) and a database that contains the testdata (objectA = 5; objectB = customer1; ...). A certain object should contain " " or 3 spaces. The script reads the test data from the access database and checks if that value corresponds with the one of the tested application.
The access database contains forms with text boxes on it....

I'm testing an application and use Access to store the test data in.
But there is a field in my application that has 4 blancs. So I want to store 4 spaces in the corresponding field in Access, but Access removed these 4 spaces after losing the focus.
Is there a possibility to store only spaces in a text field?


Thanks,

Jan