If textbox 7 = 1 then textbox 8 = A

[MFS]

Okay,


Looking for some simple vba.
I am wanting textbox 8 to show the letter "A" if textbox 7 has a 1 in it.
Can this be done in conditional formatting?

Thank In Advance,

Speck

[ranman256]

sub textbox7_afterupdate()
  if  textbox7 = 1 then textbox8  ="A"
end sub

[Missinglinq]

First off, no, it cannot done in Conditional Formatting. To advise you further, we need to know

• What kind of Form are we talking about; Single, Continuous or Datasheet View
• Will Textbox8 ever have any other data entered into it directly

Linq ;0)>

[MFS]

This would be on a continuous report.
Yes, textbox7 could have anything from a 1 in it up to an 8.
1=A
2=B
3=C
and so on.. . . . . . .
The only reason I am asking for this is because the user compares this report to another systems report that does not use 1,2,3's but A,B,C's.

[MFS]

I would hide textbox7 and only show the A,B,C's or textbox8's data.
A,B,C will not be saved in any table, simply a visual.
Am I going about this the wrong way?

[redbull]

sub textbox7_afterupdate()
  if  textbox7 = 1 then textbox8  ="A"
end sub

This is what your looking for.

[MFS]

Thank You all for your help.
I guess I was on the right track, per my thread title.