To put objects in Sheet Form cells

[mazzanrol]

Hello.
In a Sheet Form, for each row, I want to indicate a status (for example OPEN and CLOSED). I would like to indicate it by a green on red circle in a cell of the sheet. Is it possible?
In other way, is it possible to put objects or buttons in the cells of a sheet form?


Alternatively, is it possible to color a cell of a sheet form, depending on the status?
See the examples in the attachment.
Can anybody help me?
Thanks in advance.

[Toyman]

Hello.
In a Sheet Form, for each row, I want to indicate a status (for example OPEN and CLOSED). I would like to indicate it by a green on red circle in a cell of the sheet. Is it possible?
In other way, is it possible to put objects or buttons in the cells of a sheet form?
Alternatively, is it possible to color a cell of a sheet form, depending on the status?
See the examples in the attachment.
Can anybody help me?
Thanks in advance.

You can use conditional formating to achieve this. However, the status of either open or close must be part of the data for each record. You can then base your conditional formating on it. In design view of the form, create an unbound text box with the rest of your fields. In the Forms Design Tolls, select "Format". Put the unbound text box in focus and select "Conditional Formating".

[mazzanrol]

Thank you Toyman. It works.
Best regards