text field with spaces possible?

[jdesaer]

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

[NeoPa]

I couldn't manage to find a way to get it to hold any trailing spaces in a text field - sorry.

[MMcCarthy]

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

Jan,

Spaces won't mean anything. If you explain what you are trying to do and why we may be able to suggest another approach.

Mary

[jdesaer]

Jan,

Spaces won't mean anything. If you explain what you are trying to do and why we may be able to suggest another approach.

Mary

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. One of the text boxes is the name of the object that has to be tested and another text box contains the value for this object.
The problem is that I can't fill spaces in this textbox ....
Any ideas?

Thx in advance,
Jan

[MMcCarthy]

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. One of the text boxes is the name of the object that has to be tested and another text box contains the value for this object.
The problem is that I can't fill spaces in this textbox ....
Any ideas?

Thx in advance,
Jan

You can't populate with spaces alone. The only thing I can suggest is using 3 spaces plus some character like ' or using 3 other characters instead like an underline _.

Mary