Using NOW() to display long date in a report


Hi,

I want to know how should I do to display a long date format in a report
(designed in Ms-access) but it only shows July 29, 2005 instead of the
whole expression

Friday, July 29, 2005

Cheers!

Claudi

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Conditional Formatting of field with running sum of time
    ... date part (e.g. by setting the Format of the control to Short Time), ... hours do not display correctly. ... highlight with reference to the Jtime field using the expression is ... error in my report for each record in the report ...
    (microsoft.public.access.reports)
  • Re: Field Formatting
    ... Use the Formatfunction to display the 2 digits. ... Use the backslash character in the format string to specify a literal. ... I have a simple database that I've built for tracking my time usage at ... I've also built a report that shows my time usage by category for each ...
    (microsoft.public.access.reports)
  • Re: Month only field problem
    ... Don't set the format of field to mmmm. ... use a form with a combo box as the display for the month field. ... >>> Designed a database that lists all reports due to outside agencies for ... >>> agency receiving report, frequency of report (annual, quarterly, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Calculating Time
    ... DURATION is the amount of time that has ... >> You can't calculate a duration and display it using a time field ... >> minutes in a format that shows hours and minutes... ... >>> Had one issue calculating time in a Report. ...
    (microsoft.public.access.forms)
  • Create report in MS-ACCESS
    ... I'm new in creating report in Ms-Access and I have some questions. ... I want to display a text Hong Kong Dollars when a field in my database ... Input data, read ...
    (microsoft.public.access.reports)