Topics Search

Changing Field Visibility

Changing Field Visibility
Views: 9
I have a report, on which is a Sub Report that I would like to turn the visibility off based on conditions selected on a form. When I click on the Preview Report button, the report opens and a box pops up saying "OBJECT REQUIRED". The Sub Report is still visible however. The code I am using is
Sponsored Links:

Similar posts...


subform visibility

subform visibility Icon
I have inserted a subform with the contact information. The subform's visibility is set to no and a command button has been set up to change the visibility. This all works fine, but I would like to have the subform return to not visible upon changing the record or tab (meaning when you leave the tab its on that it disappears).

I have tried several ways and am having it visibleuntil I close the database out and reopen it.

Changing visibility of textboxes and labels in runtime

Changing visibility of textboxes and labels in runtime Icon
On a subform I have two textboxes and 2 labels of which I would need to change visibility on click of a label on the mainform.I do not know where to do this as the textboxes in the main formare not identified on the subform and vice versa.

Report Question

Report Question Icon
I have a form that has 4 checkbox controls on it. I want these to be an On/Off switch for subforms in a report named "rptMainReferralForm". I'm pretty sure I have the basics down. Do I need to add a subform control on the report and set the visibility to False? Then when the checkboxes are checked set the visibility to true and set to force a new page? Also what is the syntax of setting the visibility property for a form.

Footer Section Visibility

Footer Section Visibility Icon
I am trying to toggle the visibility of a group footer section based on the number of records in the details section. If the number of records in the detail section > 1 then I want to show the section footer (which has the total for the details section in it), otherwise I do not want to show the footer section.

So far I have a counter in the details section (just a running sum txtbox initialized to 1) and am able to switch on/off the section footer visibility using the Footer OnFormat event for PRINT PREVIEW, but I want to be able to do the same inReport View as well, and of course the Section Footer OnFormat event does not fire.

Of course Access 2010 will not let me change the visibility in the Footer OnPaint event.

Bottom line is that I need to toggle on/off the Section Footer visibility in Report View and Printer Preview.

Text Box Visibility?

Text Box Visibility? Icon
I currently have a form which serves as an invoice. and creates an invoice from them. Certain text boxes on the report don't need to be there if the value within them is 0.

I'm trying to figure out how to get access to recognize to make the visibility property = 0 when the value in the box is 0. So far I have tried adding a line to the button which opens the report (access macro, not VBA), using the setproperty value, where control name is 'Textbox', and visibility argument is something like 'Switch([Textbox]=0, 0,[Textbox]>0, -1), but this results in a textbox which is always invisible.

Move Form Fields Up or Down

Move Form Fields Up or Down Icon
I have a form with the following text boxes listed in a row:


I would like the visibility of any of these fields to be false if they are Null. I would also like to close the space between any field that is not visible. I can get the visibility to work, but I do not know how to compact the list. Eg. If Feature2 and Feature3 are Null, move Feature 4 up.

I am using the following code in the OnCurrent Event:

If IsNull(Me.Feature1) Then
Me.Feature1.Visible = False


Me.Feature1.Visible = True

toggle image visibility via button on form

toggle image visibility via button on form Icon
I have two images per record on a form (img1 and img2). I want their visibility to be determined by a single clickable button (btn1). Once clicked on I would like this button to change its text caption to either 'On' or 'Off' and the image visibility of img1 and img2 will both correspond to this value. This would be an unbound button, with its value applying to all records.

I am afraid that so far I have only been able to create the button. In the 'On click' event procedure I am unsure of the correct code which will check what the current caption and value of the button is, and change it to the alternative caption and value once clicked

Changing Misspelled Record

Changing Misspelled Record Icon
I want to change misspelled records, but the misspells are in the primary key of my table. By changing the values of primary key fields, can I break table relatioships? I'm not changing field names, just field values of a primary key field

Visibility of other controls

Visibility of other controls Icon
Sometimes you want to control the visibility (or other property) of one control to be based on the value in another.

I have "Option 42" which is a Y/N selection.
I also have "Label 48" which I want to become active only if Option 42 is Yes.

What is the best thing to do in this situation

Set Visibility of form objects by Group?

Set Visibility of form objects by Group? Icon
Does anyone know of a trick to set the visibility of objects on a form by group and not individually. For example, you can group elements in html by <div>. Does access have anything similar already built in? Perhaps using tag or smart tag? I ask because I am always trying to improve the visual aesthetics of my forms and im tired of writing the vba for each object