Greyed out a field

[Vina]

I have a form that runs a report and it has fields for
criteria, can someone give me an idea how i can hve a
field lock or greyed out if the report doestn require
that criteria?

Thanks
Vina

 

[Kevin Sprinkel]

Hi, Vina. Try

DoCmd.OpenReport "yourcriteriaformname"
Forms!yourcriteriaformname!txtUnneededfld.Enabled = False

HTH
Kevin Sprinkel

 

[James Goodman]

You can set this through VBA:

'To grey
Me!ControlName.Enabled = False

'To clear & enable
Me!ControlName.Enabled = True

 

[vina]

Thank you this works!!!

-----Original Message-----
Hi, Vina. Try

DoCmd.OpenReport "yourcriteriaformname"
Forms!yourcriteriaformname!txtUnneededfld.Enabled = False

HTH
Kevin Sprinkel

.