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

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

Regards
Michel
Re: format masks [message #225370 is a reply to message #225364] Mon, 19 March 2007 15:48 Go to previous message
Littlefoot
Messages: 20888
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: Sat Dec 03 12:09:16 CST 2016

Total time taken to generate the page: 0.09412 seconds