By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

text field with spaces possible?

jdesaer
P: 2
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
Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,615
I couldn't manage to find a way to get it to hold any trailing spaces in a text field - sorry.
Nov 28 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Nov 28 '06 #3

jdesaer
P: 2
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
Nov 29 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Nov 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.