Need a script to select multiple fields of a record without releasing the mouse butto

[ranju209]

Hello Everyone,

I'm new to MS Access and have very basic knowledge of VBA scripting.
I have an MS Access form which has 20 fields for each record. At the moment when I select (click) each field, the field value changes to "1" if it is "0" and vice versa. What I need is be able to select multiple fields of the same record without releasing the mouse button(similar to drag and select in MS Excel). Could someone help me with code, please?

[twinnyfo]

ranju209,

I would recommend having unbound Check Boxes associated with each Text Box.

However, your question does not specify why you must be able to select multiple text boxes. What is the purpose of the toggling between 0 and 1? Once you have multiple Text Boxes selected, what do you want to do with them?