change value of a textbox in report via vba

K

k2sarah

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
 
J

John Spencer

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"
 
Top