hide field on form if not like something

[hullstorage]

i am trying to do the following
we have 2 customers that use the same report
so what i need to do is hide a field on a report

something like this i think

if customer is not like "customer1" then
hide field "comments"

if customer is like "customer2" then
fields visable

thanks in advance

 

[lcook1974]

In that txtfield that you want to hide you could try something like this:

IIF([CustomerName]="correctAnswer",[Fieldyouwanttoshow],"")

OR VB code...like
(this not tested...just off top of my head)

IF [CustomerName]="CorrectAnswer" Then
me.[Fieldyouwanttoshow].visible = true
Else
me.[Fieldyouwanttoshow].visible = false
End if