Flag Today's Date

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is there anyway to get access to recognize when it is today's date and underline all those dates in the report?

Thanks,
Linda
 
Have you checked into Conditional Formatting?

--
Duane Hookom
MS Access MVP
--

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is
there anyway to get access to recognize when it is today's date and
underline all those dates in the report?

Thanks,
Linda
 
Not yet but I will now!

Thanks,
Linda
Have you checked into Conditional Formatting?

--
Duane Hookom
MS Access MVP
--

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is
there anyway to get access to recognize when it is today's date and
underline all those dates in the report?

Thanks,
Linda
 
I tried field value is equal to "date". The value in the control box is 2/3/05 and my computer date is 2/3/05 but I selected red for the font and an underline but nothing happened. :^ (

Linda


Have you checked into Conditional Formatting?

--
Duane Hookom
MS Access MVP
--

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is
there anyway to get access to recognize when it is today's date and
underline all those dates in the report?

Thanks,
Linda
 
You may need to use
Date()


--
Duane Hookom
MS Access MVP
--

I tried field value is equal to "date". The value in the control box is
2/3/05 and my computer date is 2/3/05 but I selected red for the font and an
underline but nothing happened. :^ (

Linda


Have you checked into Conditional Formatting?

--
Duane Hookom
MS Access MVP
--

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is
there anyway to get access to recognize when it is today's date and
underline all those dates in the report?

Thanks,
Linda
 
Gee Whiz it worked! () means function so I am saying date function? "date" what does that mean? I just typed the word date and the program automatically added the quotes for me so I just figured it knew what it was doing.

Thanks a million,
Linda
You may need to use
Date()


--
Duane Hookom
MS Access MVP
--

I tried field value is equal to "date". The value in the control box is
2/3/05 and my computer date is 2/3/05 but I selected red for the font and an
underline but nothing happened. :^ (

Linda


Have you checked into Conditional Formatting?

--
Duane Hookom
MS Access MVP
--

Hi Everyone,

Access 2000. I have a report that returns a date. =[OrderDate]+3. Is
there anyway to get access to recognize when it is today's date and
underline all those dates in the report?

Thanks,
Linda
 
It is a String with 4 characters ...d a t e

--
HTH
Van T. Dinh
MVP (Access)


Gee Whiz it worked! () means function so I am saying date function? "date" what does that mean? I just typed the word date and the program automatically added the quotes for me so I just figured it knew what it was doing.

Thanks a million,
Linda
 
Back
Top