set all controls to disable

[uoghk]

how to set all textboxes, dropdowns, buttons to disabled in simple command?
thanks.

[Gicu]

It depends on your intended purpose, you could set the AllowEdits property of the form to False, but if you want the unbound navigation\search combos to work if any you would just set the form's RecordsetType property to snapshot (=2).

Cheers,

[uoghk]

Thanks Gicu.
Although AllowEdits & RecordSetType prevent editing, i also want to set all the textboxes to disabled, so that they have a grey background.

[isladogs]

Use the tag property.
See my example database: Set Controls - Mendip Data Systems (isladogs.co.uk)

[uoghk]

thanks isladogs.
it works.