Working in Access 97, I want to add a textbox to a report that shows the
latest revision date for the database (including addition of new data).
I assume that I use the FileDateTime function. But what do I use for
the argument?

TIA >>> Robert

I would not use the file date/time for that. You would need to create a more
comprehensive specification and then program this into your forms and code.

--
Duane Hookom
MS Access MVP
--

"Robert Wagner" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Working in Access 97, I want to add a textbox to a report that shows the
> latest revision date for the database (including addition of new data). I
> assume that I use the FileDateTime function. But what do I use for the
> argument?
>
> TIA >>> Robert
>

Never mind, I got it. In the code for the section (footer) where I
wanted it, it's

txtFileDate=(FileDateTime(CurrentDb().Name))

Oddly, I couldn't just enter

=(FileDateTime(CurrentDb().Name)) as the txtFileDate's Control Source.

I had to set it in code.

Robert


"Robert Wagner" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Working in Access 97, I want to add a textbox to a report that shows
> the latest revision date for the database (including addition of new
> data). I assume that I use the FileDateTime function. But what do I
> use for the argument?
>
> TIA >>> Robert
>