| format masks [message #225364] |
Mon, 19 March 2007 14:24  |
dmack
Messages: 42
Registered: March 2005
Location: TNT
|
Member |
|
|
I am having a problem formatting a text item(I am developing using forms 6i and these are some of the properties for the text item)
Data Type : Number
Maximum length : 9
Required : No
Format mask : 000000000
The problem is while the validation seems to work fine (by not allowing non numeric characters)it does allow spaces i.e for example if only spaces are entered these spaces are committed. I have reviewed the various format masks but nothing seems to help. can anyone offer any assistance.
|
|
|
|
|
|
| Re: format masks [message #225370 is a reply to message #225364] |
Mon, 19 March 2007 15:48  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Your "committed spaces" are, actually, NULL. So, if you don't want it to happen, make this column NOT NULL (in a database) and required (in a form).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
