Access Newbie Report help

TonyF

Registered User.
Local time
Today, 11:20
Joined
Oct 15, 2010
Messages
18
Hi, I am an access newbie who has been left with a database to administer which was designed by a former employee,

I am trying to add a barcode field to a report for a date field (NEWBOX.DATE) in the format dd/mm/yyyy but the field in the table also shows the time after the date,

so when trying to apply the stars at the beginning and end of the field for the barcode reader I am getting *15/10/2010 10:15:53*

I have tried using the trim command in the query but I keep getting the error message
"The function you entered can't be used in this expression"
you may have used a doEvent, Lbound, Ubound, Spc or Tab function in an expression You may have used an aggregate function, such as count in a design grid or in a calculated control field.

Thanks for taking the time to look
Any help would be greatly appreciated
Cheers
 
Have you tried setting the field property "Format" to Short Date or something like that?
 
Hi Kryst51,

Yes I tried that in the control on the report and it brought the date through in the correct format, but then when I add the stars for the barcode it puts the time back in :(

Thanks
 
Don't know if it helps but

I am using ="*" & [DATE] & "*" in the control source of the text box on the report and will then change the font to code 39 when I can get just the date to show without the time
 
Thanks will take a look where do you apply these functions is it in the field on the report not the query ?

Cheers
and thanks for your help
 
Thanks will take a look where do you apply these functions is it in the field on the report not the query ?

Cheers
and thanks for your help

Probably in the query, and your welcome. :)
 
Hi Kryst51,

I have solved this problem thanks to your help by using the DateValue function
as below

MfgDate: (DateValue([NEWBOX]![Date]))

This gives me the date without the time and i can then add the MfgDate field to the report and add the stars in the control source using ="*" & [MfgDate] & "*"
then change the font to a barcode font.

Once again many thanks for your help

Regards
TonyF
 

Users who are viewing this thread

Back
Top Bottom