Re: Hiding A Field

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Feb 17, 3:15 pm, "Jim" <jim.be...@xxxxxxxxx> wrote:
I'm trying to have a field trigger another field's presence. I have a
field that holds a Y or N. I need for when it show N to not show the
field below it and otherwise to show all the fields.

A screenshot of the undesired producct can be obtained from me if you
have questions.

I forgot to mention the coding I have done ...

Private Sub HideBox()
'set focus on the InAContainer field aka if it is in a container
Me.InAContainer.SetFocus
'then test for results and make field invisible if it says no
If Me.InAContainer.Text = "N" Then
Me.EqContainerStoredIn.Visible = False
Else
Me.EqContainerStoredIn.Visible = True
End If
End Sub

Private Sub Form_Load()
Call HideBox
End Sub

This is in Access 2000 too. I'm not all caught up on my office
software.

.

Relevant Pages

  • Re: Loading multiline textbox in frame aborts VB6 sp5
    ... app did crash when the X was pressed. ... If Text1is placed on the form, then in code Text1's container is set ... Private Sub Form_Load ... Here is the form code:: What happens when you press the unload button? ...
    (microsoft.public.vb.bugs)
  • Re: Delete Worksheet on DeActivate
    ... The problem is that ThisWork is acting as simply an container for my VBA ... > Private Sub Workbook_SheetDeactivate ...
    (microsoft.public.office.developer.vba)
  • Re: Delete Worksheet on DeActivate
    ... The problem is that ThisWork is acting as simply an container for my VBA ... > Private Sub Workbook_SheetDeactivate ...
    (microsoft.public.excel.programming)
  • Re: is there any way to find the position of mouse click on a form
    ... Private Sub MapControls(ByVal container As ... For Each c As Control In container ... sagar wrote: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Hiding A Field
    ... 'set focus on the InAContainer field aka if it is in a container ... Private Sub Form_Load ... Place the same code in the control's AfterUpdate event. ...
    (microsoft.public.access.formscoding)