Using textboxes in Access report

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
 
D

Duane Hookom

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,...
 
Top