Using textboxes in Access report

  • Thread starter Thread starter Frank Bobak Jr
  • Start date Start date
F

Frank Bobak Jr

I am trying to use a textbox on a report as a variable
based upon a select case scenario. For example select
case 1 the textbox should read field (control source0
{ABC} case 2 should read field (control source) [DEF]

Any help or suggestions would be appreciated.

Thanks

Frank Bobak
 
You might be able to use the Choose() function. However we don't know where
you get the value.

=Choose([SomeIntegerField], [ABC], [DEF],...)

This assumes small integer values like 1, 2, 3,...
 
Back
Top