Does MS Access Report support Hide/Show fields at the Report View time? (1 Viewer)

A

accesser2003

Registered User.

Local time

Today, 10:05

Joined

Jun 2, 2007

Messages

124

• Aug 19, 2007

• #1

Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?

 

Rabbie

Super Moderator

Local time

Today, 08:05

Joined

Jul 10, 2007

Messages

5,906

• Aug 19, 2007

• #2

You can always set the contol Visible property to True/false depending on what you want. I do this in some of my reports to output a "continued on next sheet" when I have output a certain number of lines.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 03:05

Joined

Feb 19, 2002

Messages

43,196

• Aug 19, 2007

• #3

Use the Format report associated with the section that contains the controls you want to hide/show.

If x = true then
me.somecontrol.visible = false
else
me.somecontrol.visible = true
end if
If you are using A2007, report controls have events so you can do the hide/show in response to the click event of a control.

 

R

rangersedge

Registered User.

Local time

Today, 02:05

Joined

Jun 13, 2014

Messages

82

• Jun 13, 2014

• #4

How would I do this with a specific time? Say "12:00 AM" no matter the date stored?