Listbox Font Colours

[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

 

[Stephen Lebans]

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.

 

[Jacob Frankham]

Ahh OK

Thanks again !

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

Cheers

Jake

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.

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

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

 

[Stephen Lebans]

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.

Ahh OK

Thanks again !

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

Cheers

Jake

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.

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
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