1st box<2nd box<3rd box? 
Author Message
 1st box<2nd box<3rd box?

I need help, is there a way to set a input mask or something to make
sure that the time in box 1 is less than box 2 and so on.

I.E.
08:00
08:10

Not
08:10
08:00

Please help.



Wed, 25 Oct 2000 03:00:00 GMT  
 1st box<2nd box<3rd box?

Hi,

You can do it at the table design level or at the BeforeUpdate event for the
FORM (since you need both fields filled... imagine someone begining with
box2 and then, filling box1 ).

The test

    Nz(Me!Box1, 0) <= Nz(Me!Box2, 0)

may do the job, considering also the possibility that any of the two box is
empty.

Hope it may help,
Vanderghast, Acess MVP.

Quote:

>I need help, is there a way to set a input mask or something to make
>sure that the time in box 1 is less than box 2 and so on.

>I.E.
>08:00
>08:10

>Not
>08:10
>08:00

>Please help.




Tue, 31 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. 1st box<2nd box etc, In forms

2. French Canadian Spell Check <<<<<<<<<<<<<----------------help!

3. Requerying 2nd combo box after change to 1st combo box

4. Populating Two Tables from text file without Autonumber <<<<<<<<<<<

5. stupid question <<<<?????

6. ~~<|<|<|<*(#@#@@@&!!!^ATTENTION^!!!&@@@#@#)*>|>|>|>~~

7. PPT Presentations on the Web <<<<<<<

8. Write to 3 combo boxes based on choice in 1st Combo Box

9. 3 Dialog Boxes - Skip 2nd Dialog Box when EditBox >10

10. Getting data from one combo box and creating recordsource in 2nd combo box


 
Powered by phpBB® Forum Software © phpBB Group