IF Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to use an If Then statement for one of my fields in the subform.
I would to only show in the field an M if the stock code is associated with
this flag (M). Right now the tables have M or B associated with the stock
code and both codes show in the text box, i only want M to show up.

Thanks
Linda
 
Set your control source for the textbox to:
=IIf([YourFieldName] = "M",[YourFieldName],"")

Using YourFieldName of course.

I guess you could also do:

=IIf([YourFieldName] = "M","M","")

Hi,

I am trying to use an If Then statement for one of my fields in the subform.
I would to only show in the field an M if the stock code is associated with
this flag (M). Right now the tables have M or B associated with the stock
code and both codes show in the text box, i only want M to show up.

Thanks
Linda
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Thanks for your reply but i figured it out. Your help is much appreciated!

RuralGuy said:
Set your control source for the textbox to:
=IIf([YourFieldName] = "M",[YourFieldName],"")

Using YourFieldName of course.

I guess you could also do:

=IIf([YourFieldName] = "M","M","")

Hi,

I am trying to use an If Then statement for one of my fields in the subform.
I would to only show in the field an M if the stock code is associated with
this flag (M). Right now the tables have M or B associated with the stock
code and both codes show in the text box, i only want M to show up.

Thanks
Linda
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
Back
Top