Solved Unable to change colour of text in a combobox

[Sam Summers]

This one has had me baffled but i have a theory.

I have a subform with comboboxes on it. All the others display white text on a dark background but one will not change and produces black text on a dark background?

I have tried every trick i can like copying one of the others and then changing the control source etc. but still will not change.

My theory is that all the others have a list of data whereas the offending one only has one record in the selection?

Any ideas?

Many thanks

 

[MajP]

can you post a screen shot? A combo has a fore and back color property.

 

[Sam Summers]

I have messed about with every setting i know? Completely baffled

Thank you

 

[MajP]

Can you post a stripped down db with the form? Never really seen that unless you set the colors.

 

[Sam Summers]

Many thanks for your time and help. Obviously this is still in the development phase just now so bear with me

 

[Sam Summers]

Better tell you where the problem is. It is on the Enter Item form

 

[MajP]

Get rid of the > in the format in the table.
Change the row source to
SELECT ReportTbl.ReportID, UCase([ReportNumber]) AS F_ReportNumber
FROM ReportTbl
ORDER BY UCase([ReportNumber]);

It does not like the > for some reason.

 

[Sam Summers]

Brilliant that worked - Thank you SO much!