Just show some fields for input if checkbox is checked!

[cap.zadi]

Hi,



I need your help for the below matter:

I had a checkbox "OnCheck"on the main form:
The following fields shall be visible if this checkbox is clicked.

Fields are:
Address
City
Country

Else remains hidden on the form.

On Report it shall show:

If it is null then shall show "NA" otherwise the real input data.

Kindly advise.

[June7]

Options:

1. use Conditional Formating to set the Enabled state of textboxes

2. use VBA to set Visible or Enabled properties of textboxes, e.g.
Me.tbxAddress.Visible = Me.chkShow = True

On report, expression in textbox: =Nz([Address], "NA")

[cap.zadi]

Set on format the fields Visible = No and then applied on click event of checkbox:

Private Sub OnClickAddress_Click()
Me.NAddress.Visible = Me.OnClickAddress = True
Me.NCity.Visible = Me.OnClickAddress = True
Me.NCountry.Visible = Me.OnClickAddress = True
End Sub

It works fantastic.

Regarding the report:

Its giving error #Size?

Any advise?

[June7]

I have no idea why you would get that error in a textbox on report.

[cap.zadi]

Hi

Its done. Thanks