Invisible Text

[Keith166]

Can somone help me with this problem please. I have designed a golfing green fees booking system for my club using Access 97. The green fee payment options (via a combo box) are Cash, EftPos and Cheque. In my report which is a list of tee off times with the relevent members names I would like to show the EftPos payments but not any other payment method.
Any suggestions anyone?

 

[pbaldy]

Are you saying you still want those members showing in the report, just not the payment info for some of them? Normally I'd have suggested Conditional Formatting, but that was not available in 97. Try something like this in the detail format event:

If Me.ControlName = "EftPos" Then
  Me.ControlName.Visible = True
Else
  Me.ControlName.Visible = False
End If

Substituting your actual names of course.

 

[Keith166]

Invisible text

Thanks pbaldy that works just fine!

 

[Keith166]

Hi, Long time no speak. I'm continually enhancing the database that I use for Green Fees bookings but have a new problem that I don't have the experience or ability to solve:
This is the code I use to determine whether or not $25.00 applies to the booking. 6 and 8 are from my table which includes various types of $25.00 payments ie Cheque, Cash, EftPOs etc However sometimes a Credit from the pro shop may apply which is represented by 6 & 8.
Function AmountAutnChange()
If PaymentID = 6 Or PaymentID = 8 Then
AmountAutnChange = 0
Else
AmountAutnChange = 25
End If
End Function

This works really well but the green fees are about to rise to $25.50 and I want to preserve the records showing $25.00 prior to the date the $25.50 applies.

What code can I use in the above that applies the $25.50 but preserves the $25.00
Hope this makes sense.
Kind regards
Keith