Format Problem

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I'm trying to format the color of text. If sent =false then its black,
if it =true then its red.....this doesn't seem to be working....


Format(IIf([Sent]=True,"vbRed","vbBlack"(IIf([ItemType]=1,[ItemName],"
" & [ItemName]))))

Thanks
DS
 
Rick said:
Why not just use the built-in conditional formatting?
Click to expand...
Because its in for a lisbox and I have this in a Query, I need to make
the text bold or change the color based on a condition.
thanks
DS
 
I am not aware of being able to change the colors in a query. I could be
wrong, but I can't recall ever seeing a post related to colors in a query.

FYI, you posted this to the FORMS newsgroup, not the QUERY newsgroup.
 
Rick said:
I am not aware of being able to change the colors in a query. I could be
wrong, but I can't recall ever seeing a post related to colors in a query.

FYI, you posted this to the FORMS newsgroup, not the QUERY newsgroup.
Click to expand...
Because the Query is only there to populate the lisbox on the form. I'm
trying to get either bold text or colored text on certain records in a
listbox.
DS
 
Because the Query is only there to populate the lisbox on the form. I'm
trying to get either bold text or colored text on certain records in a
listbox.
DS
Click to expand...

You can try all day long, but you wont succeed.
You cannot format individual lines in a list box.
 
fredg said:
You can try all day long, but you wont succeed.
You cannot format individual lines in a list box.
Click to expand...
Thanks, I realize that now! I added a column with a asterik that
appears when the item is sent. This way I can see if the item has been
sent, it works, I'm happy!
DS
 
Back
Top