How to hide field/s depending upon the value in other fields of same form in Access

[Yousaf Shah]

Hello everybody!
I have started using Access very recently. I am trying to develop a database for my patients. Suppose there are three type of patients with similar fields except a few. I have placed a combo box named "Category" with drop down list containing values "Category 1", "Category 2" and "Category 3" displaying the respective category of patients. Suppose there is a field named "rank" that should only be visible if cbo.Categoey has value "Category 1"; a field named "Svc" to be visible if cbo.Categoey has value "Category 2" etc. with all other fields visible.
is it possible ?
if yes....! then
How......!!!

I will highly obliged by the response.

Thanks

[Lysander]

I assume you are talking about controls on a form. I do this all the time, in my case I do not make the control invisable, I disable it, but the principle is the same.

You need to put some code in the After_Update event of your combo box.

An example from my code

Private Sub HadCough_AfterUpdate()
On Error GoTo HadCough_AfterUpdate_Err
If HadCough = 0 Or HadCough = 8 Then
    HadBreathingDiff.Enabled = False
    HadNoseChestIssue.Enabled = False
    SeekHelpIllnessCough.Enabled = False
    WhoProvidedHelpCough.Enabled = False
    HowLongCareSoughtCough.Enabled = False
    TakeMedicineCough.Enabled = False
    WhatMedicineCough.Enabled = False
    WhatDoneAntibiotic.Enabled = False
Else
    HadBreathingDiff.Enabled = True
    HadNoseChestIssue.Enabled = True
    SeekHelpIllnessCough.Enabled = True
    WhoProvidedHelpCough.Enabled = True
    HowLongCareSoughtCough.Enabled = True
    TakeMedicineCough.Enabled = True
    WhatMedicineCough.Enabled = True
    WhatDoneAntibiotic.Enabled = True
End If
HadCough_AfterUpdate_Exit:
   Exit Sub
HadCough_AfterUpdate_Err:
   MsgBox Err.Description & " in HadCough_AfterUpdate"
   Resume HadCough_AfterUpdate_Exit
End Sub

For you, you would need something like this

Private Sub Category_AfterUpdate()
Select Case Category
  Case "Category 1"
     svc.visible=true
     otherfield.visible=true
     thisfiedl.visible=false
  Case ""Category 2"
     etc etc
end select