Hide/ Unhide

[soldieryap]

in the report,
if i have a table<electrical>, if the electrical is &quot;TV&quot;, then show the &quot;Cost&quot; of the TV, if the electrical is &quot;Games&quot;, then the &quot;cost&quot; will be hide and replace with the &quot;Name of the Game&quot;? can it do in report?

EXAMPLE:

Electrical: TV
Cost: $1000
(hide the&quot;name of game&quot;, unhide &quot;Cost&quot

Electrical: Games
Name of Game: Red Alert 2
(hide the &quot;Cost&quot;, unhide &quot;Name of Game&quot

thanks

 

[WP]

You can test the values of fileds in the on format of the detail in your report :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Electrical = &quot;Game&quot; Then
cost.Visible = False
GameName.Visible = True
Else
cost.Visible = True
GameName.Visible = False
End If

End Sub

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[soldieryap]

Is this using the VB to write the code? if don't using VB, got other ways to do that?