MAking things visable

[Simon]

I have a Report that will dispay locations of different shops

I have 5 Maps (Images) on the report all on top of each other and not
Visable

Map1
Map2
Map3
Map4
Map5


On the report it will dispay the shop address and a Shop ID Number

1
2
3
4
5


What i would like to code is that if the shop ID on the repot is 5 it
will make Map5 visable

If Shop ID is 2 it will show Map 2


Hope you can help me

Thanks

 

[Tom van Stiphout]

On Fri, 25 Apr 2008 06:26:04 -0700 (PDT), Simon <[email protected]>
wrote:

Try this:
In the Detail_OnFormat event write:
if Me.ShopID >= 1 and Me.ShopID<=5 then
Me.Controls("Map" & Me.ShopID).Visible = True
end if

-Tom.