Validation Rule Text

[Guest]

I need to set up a field that the person entering the information could only
enter 1.0 Million thru 9999.9 Billion. Is there a way to do this?

 

[storrboy]

Look up the Validation Rule and Validation Text properties of the
control in question. Help file explains how.

 

[Guest]

I have already looked it up and it showed how to do a date but not what I am
trying to do.

 

[storrboy]

I have already looked it up and it showed how to do a date but not what I am
trying to do.

You have to take that knowledge and either apply it to your situation
or read further into other topics.

Rule: Between 1000000 AND 1000000000
Text: "Man you are rich."

 

[Guest]

Hi

I take you are wanting to enter the yearly wage of most MVP's. OK ;-)

Open the table in design view and select the row containing the field you
want to validate.

In the Validation row (at the base of the page) enter this

1000000 And <99999000000000

Not sure about the number fo zeros - in the UK a million has 6 zeros and a
billion has 9 (I think - but may be wrong)

Hope this helps

 

[Guest]

I think I did not make myself plain in my question. I want it to be that
they can only enter the text 1.0 Million thru 9999.9 Billion. For example:
2.0 Million or 3.0 Billion or 4.0 Billion or 3.5 Million etc.

 

[John Nurick]

Perhaps something like this:

Is Null Or Like "[1-9].# [BM]illion" Or Like "[1-9]#.# [BM]illion" Or
Like "[1-9]##.# [BM]illion" Or Like "[1-9]###.# [BM]illion"

 

[John W. Vinson]

I need to set up a field that the person entering the information could only
enter 1.0 Million thru 9999.9 Billion. Is there a way to do this?

Wayne's answer is correct - but just be aware that a Number field won't handle
that size value - you'll need to use Currency or Decimal. Also, the words
"million" and "billion" are not number values; to enter 9999.9 billion you'll
need to either write it out as 9,999,900,000,000 or use scientific notation,
9.9999E12.

John W. Vinson [MVP]

 

[Guest]

Thanks Nurick that was what I was looking for.

Perhaps something like this:

Is Null Or Like "[1-9].# [BM]illion" Or Like "[1-9]#.# [BM]illion" Or
Like "[1-9]##.# [BM]illion" Or Like "[1-9]###.# [BM]illion"

I think I did not make myself plain in my question. I want it to be that
they can only enter the text 1.0 Million thru 9999.9 Billion. For example:
2.0 Million or 3.0 Billion or 4.0 Billion or 3.5 Million etc.