Reports showing more than needed

[Mike]

I have a table that contains a field and this field is called "DateEntered".
The default value for this fields is " =Now() " and was created simply to
track when changes were made to each record. I have this field in a query
that eventually gets put into a report. The issue that I'm having is that
when showing up on the report it not only give me the day (Ex. 05/08/2008)
but it also shows the time (Ex. 05/08/2008 1:07:10 PM). Its also showing the
date and time in the table and thats fine. Is there a way that I can only
display the date minus the time on the report?

 

[KARL DEWEY]

Open the report in design view, click on menu VIEW - Properties. Click on
the textbox for DateEntered and in the Format property enter "Short Date"
without quotes.

 

[Mike]

Hey Karl,
Thanks much! It worked like a charm however I have one field in the
report that contains the following:

="Date:" & " " & [DateEntered]

This is the only field that its not working on. Is there a work around for
that field in the report?

Mike

 

[KARL DEWEY]

Try this --
="Date:" & " " & Format([DateEntered], "Short Date")

--
KARL DEWEY
Build a little - Test a little

Hey Karl,
Thanks much! It worked like a charm however I have one field in the
report that contains the following:

="Date:" & " " & [DateEntered]

This is the only field that its not working on. Is there a work around for
that field in the report?

Mike

Open the report in design view, click on menu VIEW - Properties. Click on
the textbox for DateEntered and in the Format property enter "Short Date"
without quotes.

 

[Mike]

Hey Karl! You are the MAN!!! Worked like a charm. Now that i know little
things like how to set certain properties without actually setting them I
will use them all for future reference. And I will take your advice:

"Build a little - Test a little"

Thanks again!

Try this --
="Date:" & " " & Format([DateEntered], "Short Date")

--
KARL DEWEY
Build a little - Test a little

Hey Karl,
Thanks much! It worked like a charm however I have one field in the
report that contains the following:

="Date:" & " " & [DateEntered]

This is the only field that its not working on. Is there a work around for
that field in the report?

Mike

Open the report in design view, click on menu VIEW - Properties. Click on
the textbox for DateEntered and in the Format property enter "Short Date"
without quotes.
--
KARL DEWEY
Build a little - Test a little


:

I have a table that contains a field and this field is called "DateEntered".
The default value for this fields is " =Now() " and was created simply to
track when changes were made to each record. I have this field in a query
that eventually gets put into a report. The issue that I'm having is that
when showing up on the report it not only give me the day (Ex. 05/08/2008)
but it also shows the time (Ex. 05/08/2008 1:07:10 PM). Its also showing the
date and time in the table and thats fine. Is there a way that I can only
display the date minus the time on the report?