 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006change value of a textbox in report via vba
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" > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.