How to change input mask in DB via code?

[Gwena]

I Originally posted this on Microsoft: Access Tables and Relationships Forum but got no answer so maybe this is a better place for it:

Is there a way to change via code the input task of a field in a giving table?
Thanx
Gwen

 

[pjm]

Hi

currentdb.TableDefs("myTable").Fields("MyField").Properties("inputmask")="InputMask"

HTH

pjm

 

[Gwena]

Hi pjm
I tried this and got this error: Property not found. (Error 3270)

 

[pjm]

Hi

This will change the inputmask property but it has to exist first.

See following link for how to append to the properties collection:-

http://visualbasic.about.com/od/usevb6/l/aa101602a.htm

HTH

pjm

 

[Gwena]

Thanks
Working great!!
Gwen