change value of a textbox in report via vba

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

Guest

is it possible to change the text shown in a textbox of inside a report via
vba. i.e. i desire to program that if the current value of a field is NA,
then on my report i want to display "-". if so how can i do this. thks ken
 
Change the source of the control to
=IIF([SomeField]="NA","-",[SomeField])

Make sure the control's name is not the same as the field name. You can
probably just change the control to "txtSomeName"
 
Back
Top