DLookup in Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 13 Jul 2007 22:44 GMT

I need to use a date check in conditional formatting. I have a table of
extra info that I need to use the DLookup.

I tried to use this formula, but the change would not work:
If field is less than Date()-dLookup([dhallexpiration],[tblExtrainfo])

That didn't work. Anyone have any tips?

Thanks As Always
Rip

Reply to this Message

Ken Snell (MVP) - 14 Jul 2007 00:23 GMT

You need " characters in the DLookup function call:

Date()-DLookup("dhallexpiration","tblExtrainfo")

Signature

Ken Snell
<MS ACCESS MVP>

>I need to use a date check in conditional formatting. I have a table of
> extra info that I need to use the DLookup.
[quoted text clipped - 6 lines]
> Thanks As Always
> Rip

Reply to this Message

Marshall Barton - 14 Jul 2007 00:46 GMT

>I need to use a date check in conditional formatting. I have a table of
>extra info that I need to use the DLookup.
>
>I tried to use this formula, but the change would not work:
>If field is less than Date()-dLookup([dhallexpiration],[tblExtrainfo])

DLookup's argument are strings so they need quotes around
them:

Date() - DLookup("dhallexpiration", "tblExtrainfo")

But that is going to be pretty slow. It would be better if
you included that data in the form's record source query.

Signature

Marsh
MVP [MS Access]

Reply to this Message