Making boxes visible/invisible (1 Viewer)

A

AnTa

New member

Local time

Today, 04:31

Joined

Sep 27, 2018

Messages

5

• Jun 14, 2019

• #1

Hello, can anyone help me with this?

I have one report, with 10 fields: TestName1, TestName2,....TestName10. And I have 10 boxes: BoxTestName1, BoxTestName2,...BoxTestName10.

I want to make the boxes visible only when the corresponding field is not null, and invisible when the corresponding field is null.

Can anyone guide me with details cuz I'm not experienced with Access.

Thank you

 

theDBguy

I’m here to help

Staff member

Local time

Today, 04:31

Joined

Oct 29, 2018

Messages

21,449

• Jun 14, 2019

• #2

Hi. To hide the textboxes on the report, you can use code in the format or print event. Why do you want to do it, by the way?

 

A

AnTa

New member

Local time

Today, 04:31

Joined

Sep 27, 2018

Messages

5

• Jun 14, 2019

• #3

Hi, cuz for different records the number of notnull fields are different.
For example:
In record A, I have 4 data from fields TestName1,...TestName4, the rest are null, so I only want Box1,..Box4 to appear in the report, the other 6 are invisible.
In record B, I have 8 data from fields TestName1,...TestName8, the rest are null, so I want Box1,..Box8 to appear in the report, the other 2 are invisible.

 

K

KHallmark

Registered User.

Local time

Today, 04:31

Joined

Jul 11, 2019

Messages

12

• Jul 11, 2019

• #4

Go to the Format tab, Change Shape Outline to transparent, and Shape Fill to Transparent