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
|
|||
|
|||
Highlighting
I want to highlight all the discharge dates in my db but acess won't allow me
to do it for just certain records. One of my co-workers suggested I convert my db from acess to excel. My question: can I highlight certain records using acess or should I convert my db to excel? Thank you -- Denise Perrelli VNASCC Receptionist |
#2
|
|||
|
|||
Highlighting
On Wed, 2 Sep 2009 13:44:02 -0700, DeniseP09 wrote:
I want to highlight all the discharge dates in my db but acess won't allow me to do it for just certain records. One of my co-workers suggested I convert my db from acess to excel. My question: can I highlight certain records using acess or should I convert my db to excel? Thank you How does Access (or we) know which record to highlight? If you have Access 2000 or newer you can use Conditional Formatting in the [DateField] control on Forms and Reports. In Form/Report design view, select the control. Click on Format + Conditional Formatting. Then depending upon your criteria for determining the control's color, set Condition1 to either "Has Focus", "Field Value Is", or "Expression Is" and enter the value, or expression in the next dialog box. (Note: if it is an expression, do NOT use the = sign.) Select the color you wish. Save the changes. Also, in Reports, depending upon the criteria to determine which records to highlight on the page, you can use code. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Highlighting
Hi Fred - I printed your instructions and I'll let you know how it turns out.
Thank you -- Denise Perrelli VNASCC Receptionist "fredg" wrote: On Wed, 2 Sep 2009 13:44:02 -0700, DeniseP09 wrote: I want to highlight all the discharge dates in my db but acess won't allow me to do it for just certain records. One of my co-workers suggested I convert my db from acess to excel. My question: can I highlight certain records using acess or should I convert my db to excel? Thank you How does Access (or we) know which record to highlight? If you have Access 2000 or newer you can use Conditional Formatting in the [DateField] control on Forms and Reports. In Form/Report design view, select the control. Click on Format + Conditional Formatting. Then depending upon your criteria for determining the control's color, set Condition1 to either "Has Focus", "Field Value Is", or "Expression Is" and enter the value, or expression in the next dialog box. (Note: if it is an expression, do NOT use the = sign.) Select the color you wish. Save the changes. Also, in Reports, depending upon the criteria to determine which records to highlight on the page, you can use code. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|