Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress fields on report in certain conditions 1

Status
Not open for further replies.
AyJayEL

AyJayEL

Technical User
Jan 30, 2001
425
GB
I am using Access 2000. I would like to suppress or make a field invisible on a report when certain conditions occur. ie when B is ticked don't show Return Date 1. Can anyone tell me how to do this please? Learn something new every day *:->*
 
Sort by date Sort by votes
Use the Format event of the Detail section of the report. Add the following sort of code to the event:

Dim R as Report: Set R = Me
If R!B then
R!ReturnDate1.Visible = False
Else
R!ReturnDate1.Visible = True
End If

Hope this helps, Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
 
Upvote 0 Downvote
I love this community! Excellent worked like a dream!

Many thanks Andrea. Learn something new every day *:->*
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
4K
Norman Sherlock
Norman Sherlock
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
473
Andrzejek
Andrzejek
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
426
strongm
strongm
bobbyer
  • Locked
  • Question
ms accesss option group on report
Replies
4
Views
213
bobbyer
bobbyer

Part and Inventory Search

Sponsor

Back
Top