Home » Developer & Programmer » Forms » format masks
format masks [message #225364] Mon, 19 March 2007 14:24 Go to next message
Messages: 42
Registered: March 2005
Location: TNT
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 #225366 is a reply to message #225364] Mon, 19 March 2007 14:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think this question belongs to Forms forum and not SQL Experts one.

Re: format masks [message #225370 is a reply to message #225364] Mon, 19 March 2007 15:48 Go to previous message
Messages: 21131
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).
Previous Topic: how to wrap text in excel cell using ole2?
Next Topic: Reading data out of file
Goto Forum:

Current Time: Fri Jul 28 10:21:51 CDT 2017

Total time taken to generate the page: 0.16762 seconds