How to ignore InputMask if nothing is entered?

[pctest]

If an inputmask is XX.XXX.XXX but I don't wan't the '.' to be saved if nothing is entered, how to do it?


Thank you for any help.

 

[omr1119]

pctest,
try this.

if substr(m.var,1,2)=" "
repl m.var with " "
else
insert into alias() from memvar
endif

 

[DSummZZZ]

You're going to get an error with this statement:
repl m.var with " "

But if you have the control bound the field, you may have to bind it to a memory variable instead:

IF ALLTRIM(ThisForm.Text1.Value) == ".   ."
   m.var = Chrtran('ThisForm.Text1.Value', '.', '')
   REPLACE MyTable.Field WITH m.var
ENDIF

Or you may need to create a trigger to handle the conversion.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Mike Lewis]

Am I missing something here? Why not just put "R" in the Format property?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com