[Solved] Base table with different background colors

[Bugsie1977]

Ok, I don't think this can be done with writing a code or macro and if not, I accept that.

I have a form for a database with drop down options tasks. The dropdown database table is used for many different job requirements.
i.e. Not Needed, Needed, Pending, Done

I would like to have each of the options a different color so when looking at the form I can see instantly each by color. Such as Not Needed might be cyan, Needed = yellow, Pending = pink and Done = light green. The words would be there but also having the colors might make it wash to scan for all yellow and know these are action items.

Again, can this be done with the table format without a macro? If no - no problem, just thought I would ask.

I am new to openoffice base so still learning.

Thanks in advance.

John

[Villeroy]

No, there is no way to do this with a form. [Tutorial] Using registered datasources in Calc describes how you can create a simple report on a Calc sheet where the data are linked to a cell range. With the right template and with cell styles, it is easy to apply conditional formatting.
I use the attached template for such reports.

[Bugsie1977]

Thanks for the information and the confirmation that I will need to be much more advanced in database programming. LOL

Have a wonderful day.

[Villeroy]

No programming at all. No macro can colorize rows in a table control because every row is an instance of the same set of data conrols. If a column of a table control is a text box, all rows are instances of the same text box.
Just prepare a spreadsheet document, drag a query from the data source window into the sheet and apply conditional formatting.