Listbox Font Colours

  • Thread starter Thread starter Jacob Frankham
  • Start date Start date
J

Jacob Frankham

Hi there !

I have a query which is populating a listbox with some office names.
I have another field which is produced from the query [contractEndDate]
(although this field is not included in the listbox), and what I want to do
is where [contractEndDate] is less than todays date I want to make the
office appear in red.

How do I change the colour of the text of individual rows in a listbox?

Or indeed is this possible?

Many thanks

Jake
 
Not possible, period. Instead, use a ListBox with Conditional
Formatting.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Ahh OK

Thanks again !

How do I make a SubForm look like a listbox though ??

Cheers

Jake

Stephen Lebans said:
Sorry Jacob, I meant to type SubForm in place of ListBox!
:-(


HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jacob Frankham said:
Ok

Thanks for that

Just one other thing though, it won't let me do conditional formatting on a
listbox, the option is greyed out - any ideas?

Cheers

Jake
Stephen Lebans said:
Not possible, period. Instead, use a ListBox with Conditional
Formatting.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Hi there !

I have a query which is populating a listbox with some office names.
I have another field which is produced from the query
[contractEndDate]
(although this field is not included in the listbox), and what I want
to do
is where [contractEndDate] is less than todays date I want to make the
office appear in red.

How do I change the colour of the text of individual rows in a
listbox?

Or indeed is this possible?

Many thanks

Jake
Click to expand...
Click to expand...
Click to expand...
 
I think Arvin has a sample here:
http://www.datastrat.com/Download2.html
http://www.datastrat.com/Download/SubformDemo.zip

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jacob Frankham said:
Ahh OK

Thanks again !

How do I make a SubForm look like a listbox though ??

Cheers

Jake

Stephen Lebans said:
Sorry Jacob, I meant to type SubForm in place of ListBox!
:-(


HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jacob Frankham said:
Ok

Thanks for that

Just one other thing though, it won't let me do conditional
Click to expand...
formatting
on a
listbox, the option is greyed out - any ideas?

Cheers

Jake
Not possible, period. Instead, use a ListBox with Conditional
Formatting.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Hi there !

I have a query which is populating a listbox with some office names.
I have another field which is produced from the query
[contractEndDate]
(although this field is not included in the listbox), and what
Click to expand...
I
want
to do
is where [contractEndDate] is less than todays date I want to
Click to expand...
make
the
office appear in red.

How do I change the colour of the text of individual rows in a
listbox?

Or indeed is this possible?

Many thanks

Jake
Click to expand...
Click to expand...
Click to expand...
 
Back
Top