Column Filter

[vijip]

Hello all,

I am new to access and new to this forum too. I have an application which uses microsoft access 2000(9.0.3821 SR-1) for the forms,reports etc . This application uses microsoft visual basic 6.0 for the code.
I have many fileds in the form and i need to restrict the user to enter only certain number of characters in those fields. How can i do it? Is there any filter or property that i can set in those fields? Please help.

Thanks,
Viji

 

[elbweb]

a simple way to do it is the input masks, look under the 'data' tab on the properties of the text box, and then pess the little '...' button next to it, it will guide you through creating the right mask

 

[vijip]

column filter

I don't see a way to input mask on a character column.

 

[elbweb]

is this part of a datasheet?

try doing it within the design of the table, then maybe it should be carried over wherever the data is bound.