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?

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

I have already looked it up and it showed how to do a date but not what I am trying to do."storrboy" wrote:> Look up the Validation Rule and Validation Text properties of the> control in question. Help file explains how.> > 

On Mar 21, 2:32 pm, jrp444 <jrp...@discussions.microsoft.com> wrote:> I have already looked it up and it showed how to do a date but not what I am> trying to do.>> "storrboy" wrote:> > Look up the Validation Rule and Validation Text properties of the> > control in question. Help file explains how.You have to take that knowledge and either apply it to your situationor read further into other topics.Rule: Between 1000000 AND 1000000000Text: "Man you are rich."

HiI 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 <99999000000000Not 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-- WayneManchester, England."jrp444" wrote:> 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?

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."jrp444" wrote:> I have already looked it up and it showed how to do a date but not what I am > trying to do.> > "storrboy" wrote:> > > Look up the Validation Rule and Validation Text properties of the> > control in question. Help file explains how.> > > > 

Perhaps something like this:Is Null Or Like "[1-9].# [BM]illion" Or Like "[1-9]#.# [BM]illion" OrLike "[1-9]##.# [BM]illion" Or Like "[1-9]###.# [BM]illion"On Wed, 21 Mar 2007 12:48:15 -0700, jrp444<jrp444@discussions.microsoft.com> wrote:>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.>>"jrp444" wrote:>>> I have already looked it up and it showed how to do a date but not what I am >> trying to do.>> >> "storrboy" wrote:>> >> > Look up the Validation Rule and Validation Text properties of the>> > control in question. Help file explains how.>> > >> > --John Nurick [Microsoft Access MVP]Please respond in the newsgroup and not by email.

On Wed, 21 Mar 2007 11:10:35 -0700, jrp444 <jrp444@discussions.microsoft.com>wrote:>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 handlethat 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'llneed to either write it out as 9,999,900,000,000 or use scientific notation,9.9999E12.             John W. Vinson [MVP]

Thanks Nurick that was what I was looking for."John Nurick" wrote:> 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"> > On Wed, 21 Mar 2007 12:48:15 -0700, jrp444> <jrp444@discussions.microsoft.com> wrote:> > >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.> >> >"jrp444" wrote:> >> >> I have already looked it up and it showed how to do a date but not what I am > >> trying to do.> >> > >> "storrboy" wrote:> >> > >> > Look up the Validation Rule and Validation Text properties of the> >> > control in question. Help file explains how.> >> > > >> > > > --> John Nurick [Microsoft Access MVP]> > Please respond in the newsgroup and not by email.>