Replies

Fixed the quote issue and also tried the On Format event without success. Thanks!

BackColor appears as either white or transparent.

Tried this as well….still doesn’t work. Any other suggestions?

Yes, the values in DocStatus are text.

I figured it out!

If I set the tab stop property of the control to “no” and then use the onOpen event of the form with ‘Me.sfmJobs![cboProject].visible = False’ it works fine!!

This subform is also used/shared as a subform for other forms. Changing any of the control properties would also be reflected in all instances the subform it is used in. I need to be able to hide the control of a subform when the parent form is opened.

The field I am trying to hide is located on a tab control in a subform. This subform is also used on another form so I can’t set the control visible property to no.

I have tried using “Me.sfmJobs![cboProject].Visible = False” in the onOpen event of the form, however, this doesn’t work. I receive a runtime error 2165 stating you can not hide a control that has the focus.

This works great thank you very much !

Just wanted you to know that this was on old database I inherited and would never use those naming conventions. It needs MAJOR revamping and renaming fields is only one aspect.

Thanks again, you’ve been a great help!

Thanks for your response but this doesn’t work either. One would think this should be simple! No to bagels, LOX is for Liquid Oxygen.

Regards!

I am using an option button and would like to be able to toggle the value of the button based on the contents of another field. It works great when I input information into the other field, however, when I delete the contents of the field the option value does not change accordingly. I am using the following for the On Change click event:

If IsNull(Me.[STORAGE – LOX]) Or IsEmpty(Me.[STORAGE – LOX]) Then
Me.LOXOption = 0
ElseIf Me.[STORAGE – LOX] >= 0 Then
Me.LOXOption = 1
End If

Thanks for any assistance. (I am using Access97)