Field Size...Old Access User

[grpdcop]

I know this is a stupid question, but as an old Access user, I cannot figure out how to limit a field size (of all things....)

Also, I would like to limit a field size to 6, and fill with 0's on the empty spaces.

I have about 4 FMP books...and I can't find anything about limiting field sizes... Thanks for anyone that could help me out regarding this silly question.

[Kurt Knippel]

quote:

---

Originally posted by grpdcop:

I know this is a stupid question, but as an old Access user, I cannot figure out how to limit a field size (of all things....)

Also, I would like to limit a field size to 6, and fill with 0's on the empty spaces.

I have about 4 FMP books...and I can't find anything about limiting field sizes... Thanks for anyone that could help me out regarding this silly question.

---

FMP does not impose user-defined limits on field length. You could simply allocate space on the layout for only six characters, or put a validation message on the field if it exceedes 6 characters.

Putting "0" in for the missing characters is easy. Define a calculation as follows: Right("000000" & DataEntryField, 6). This will take the right 6 characters of the combination of your data entry and the zeros.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[grpdcop]

Thanks a lot, Kurt - that explains a lot!