I have a combo box in a single view form with a combo box. Selecting a different listing from the combo box changes the color text color in the form. This part works fine.

Is it possible to store the color text to the record in the table? The reason I want to store the color text is so that when I create a report, I can print it in color. Thanks

Create a Long Integer field to hold the value of the colour for each row.
Then use the forms onCurrent Event to set the colour of the form.

Create a Long Integer field to hold the value of the colour for each row.
Then use the forms onCurrent Event to set the colour of the form.

I went into the table and changed the field size to long integer but some field (data type) won’t let me. Am I missing something?