If statement

D

dar

I would like to write an If statement that will fill more than 2 text boxes.

I can do one at a time like this:
If A = >0 then B = "6"
If A = > 0 then C = "7"
If A = >0 then D = "8"
I would like to say
If A = >0 Then B = "6" And C = "7" And D = "8"

However I get an error
Is there a better way?
 
S

Stefan Hoffmann

hi,
I would like to write an If statement that will fill more than 2 text boxes.

I can do one at a time like this:
If A = >0 then B = "6"
If A = > 0 then C = "7"
If A = >0 then D = "8"
I would like to say
If A = >0 Then B = "6" And C = "7" And D = "8"

However I get an error
Is there a better way?
Click to expand...
yup:

If A => 0 Then
B = "6"
C = "7"
D = "8"
End If


mfG
--> stefan <--
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
J

jahoobob via AccessMonster.com

Good grief George! It appears as though your AUTO-REPLY has done so to a
number of thread in this group. Hope you can fix it so it doesn't do this
the next time you leave for a few days.
Bob
 
Top