If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting in a list box
Hi,
I know in older versions of access that you can't apply conditional formatting to list boxes. Does anyone know if access 2003 can achieve conditional formatting in list boxes thanks Lutan |
#2
|
|||
|
|||
conditional formatting in a list box
"lutan" wrote in message ... Hi, I know in older versions of access that you can't apply conditional formatting to list boxes. Does anyone know if access 2003 can achieve conditional formatting in list boxes thanks Lutan |
#3
|
|||
|
|||
conditional formatting in a list box
"lutan" wrote in message ... Hi, I know in older versions of access that you can't apply conditional formatting to list boxes. Does anyone know if access 2003 can achieve conditional formatting in list boxes thanks Lutan |
#4
|
|||
|
|||
conditional formatting in a list box
Access 2003 also does not have conditional formatting in either list or
combo boxes. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "lutan" wrote in message ... Hi, I know in older versions of access that you can't apply conditional formatting to list boxes. Does anyone know if access 2003 can achieve conditional formatting in list boxes thanks Lutan |
#5
|
|||
|
|||
conditional formatting in a list box
Hi Arvin,
I just tried conditional formatting in Access 2002 for a combo box, and it works fine. Open the Northwind Customers form and add the following format to the Country combo box: Field Value Is equal to "Germany" and set a different font color. Then see what happens when you open the form to Alfreds Futterkiste. Tom http://www.access.qbuilt.com/html/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Arvin Meyer [MVP]" wrote: Access 2003 also does not have conditional formatting in either list or combo boxes. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access |
#6
|
|||
|
|||
conditional formatting in a list box
On Wed, 28 Dec 2005 08:46:03 -0800, Tom Wickerath wrote:
Hi Arvin, I just tried conditional formatting in Access 2002 for a combo box, and it works fine. Open the Northwind Customers form and add the following format to the Country combo box: Field Value Is equal to "Germany" and set a different font color. Then see what happens when you open the form to Alfreds Futterkiste. Tom http://www.access.qbuilt.com/html/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Arvin Meyer [MVP]" wrote: Access 2003 also does not have conditional formatting in either list or combo boxes. Tom, I believe Arvin meant that conditional formatting was not possible while the combo was in drop-down, not after a selection was made. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#7
|
|||
|
|||
conditional formatting in a list box
Hi Tom,
As Fred says, not when dropped down and for a list box (which is always in drop down g), not at all. The OP was looking for something to make a value stand out from the rest, and that can't be done with conditional formating in a list or combo box. A smal subform would allow conditional formatting, and can be made to look somewhat like a list box. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Tom Wickerath" AOS168b AT comcast DOT net wrote in message ... Hi Arvin, I just tried conditional formatting in Access 2002 for a combo box, and it works fine. Open the Northwind Customers form and add the following format to the Country combo box: Field Value Is equal to "Germany" and set a different font color. Then see what happens when you open the form to Alfreds Futterkiste. Tom http://www.access.qbuilt.com/html/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Arvin Meyer [MVP]" wrote: Access 2003 also does not have conditional formatting in either list or combo boxes. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access |
#8
|
|||
|
|||
conditional formatting in a list box
Hi Arvin,
I was just answering the statement you wrote....not what you meant to write. Tom http://www.access.qbuilt.com/html/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Arvin Meyer [MVP]" wrote: Hi Tom, As Fred says, not when dropped down and for a list box (which is always in drop down g), not at all. The OP was looking for something to make a value stand out from the rest, and that can't be done with conditional formating in a list or combo box. A smal subform would allow conditional formatting, and can be made to look somewhat like a list box. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
difficulty with conditional formatting | Deb | General Discussion | 0 | March 23rd, 2005 06:13 PM |
conditional formatting question | Deb | General Discussion | 0 | March 23rd, 2005 02:07 AM |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |