Creating an Input mask in Access

Dear Vb users,

How do I create an Input mask in my field.

Set DB = CreateDatabase(DbSetting, dbLangGeneral)
Set TD = DB.CreateTableDef("MyTable")
With TD
.Fields.Append .CreateField("MyField"), dbText)
End With

How do I get an input mask for field "MyField??????

Nice greetings,

Michelle.

Hello Michelle
There are several Ways You can create input masks.
One:

If your text field is bound to the field, go to the properties of it and click on the Data tab. In there is a setting to set up the mask.

Two:

If it isn't bound to the field you can set up the input mask in The design of the table (click on the field you want and half way down the property list is the input mask

If you need any more help on creating a specific mask reply back.

Good Luck
Ian

[Edited by Ianpbaker on 04-18-2000 at 10:56 AM]

Hello Ianpbaker,

Thanks for helping me.

In VB I want to create an Input Mask for a field-table

Nice regards,

Michelle.

Hello Michelle
:confused:
Could you please explain more about your input mask as I don't quite understand what you mean by field-table

Cheers

Ian

Hello, Ianpbaker

If you start the office program MS ACCESS, you have the possibility to design your table.
In the table design you are seeing in the general tab the choice: "Input Mask"
Most of these properties I can set in VB. a Big question is how to set the "Input Mask"

Do you know the answer???

Thanks for reading my question.

:) Thanks,

Michelle.

Hi Michelle

If You select the field that you want to make the input mask for and then click in the input mask text box a three dotted button will appear. Click on it and it will bring up the default masks. If you want to make one of your own click on edit list, goto a new record (the > * button) and create a new one. Most of the mask characters are the same as in VB.

Good luck
Ian

Hi Ianpbaker,

Thanks for the information.

Michelle.