Data Validation - multiples of

J

Jessica

Hi,

I want to set a combo box to only allow multiples of 0.25. E.g. 0.25, 0.5,
0.75, 1.0, 1.25, etc. I don't want there to be a maximum.

I saw an example for Excel with the MOD function but I don't know if there
is something like that for Access.

I know I could create a table, but is there a different method?

~Jessica
 
L

Linq Adams via AccessMonster.com

I don't want there to be a maximum.

Sorry, but I think you need to re-think this requirement! Exactly how/where
do you plan on storing the infinite number of items that are implied with "no
maximum?" Access is not an bottomless pit for data, like a Black Hole! And
how could you practically scroll thru a gazillion gazillion possible items?

A better approach, if you truly need there to be no maximum, is to have users
enter a number in a textbox and do validation code in the BeforeUpdate event
of the textbox to insure that the number entered is evenly divisible by .25.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top