Allow Users to Change Background Colors on Individual Cells/Rows in Frontend

[kellydigital]

We have created a shared MS Access database for about 5 users. We have split the file into tables (Backend) and forms (Frontend). The backend is on a shared drive. The users front end is on their own PCs linked to the backend.



I would like users to have the ability to highlight a cell or a row with any color but only on their own front end.

The background color button seems to change the background color of all the cells.

[Bob Fitz]

The background color button seems to change the background color of all the cells

Then you are setting the background property of the form rather than the background property of the control. Show us the code you are using.

[CJ_London]

Also is your form a datasheet or continuous/single form?

[kellydigital]

Hi Bob - I'm not using any code yet. Just trying to figure out how to do it.

The background color button is just the default button in Access.

[kellydigital]

Hi Ajax - it looks like a spreadsheet (datasheet) view

[CJ_London]

You will need to use conditional formatting - perhaps choose ‘if field has focus’ rule for highlighting individual controls (not cells which is an excel construct)

If you want to highlight a row, you will need some code and a different conditional formatting rule - and your data will need a unique Id

The code will depend on how you want a user to select a row (or a specific control, regardless of focus) usual basis would be a button (not available in datasheet) or perhaps a double click event on one or more controls

Be clear about that and I’m sure some example code will be forthcoming

You might find this link helpful
https://www.access-programmers.co.uk/forums/threads/multi-select-form.289116/