Web Development

Ask something
Discussion Locked

Access question

0 helpful
5 replies

by flores

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to limit to enter only 5 digits number to a field in access. Is there a way to do this? Thanks.

5 replies

by dklippert

In design view, select the field. Make the Data Type Number. In the bottom part of the Design dialog box, go to Input Mask.
Enter "#####" (without th quotes). If you want zeros displayed, us "00000"

This discussion is closed to new replies.