chart date formats - going mental!

[mikecollett]

for the life of me i cant work this one out!

i have a simple little table that has a date and a number that i want to chart.

i have a simple little select query (date range specified in a form) to select my data. no calc required.

i have a simple little line chart on a simple little report that shows the *beep* dates in long format when i want short format.

formatting the axis does not work.
detail section, event, on format,do events trick does not work.

a little history that may have wonked it up;
the table was originally general date format. i have changed it to short.
the form used Now() and Now()-100 for date range for default values. is now 01/01/03 and user type in other. both short date format.

query is short date format.

query behind the graph is also short date format.

every *beep* thing i can find i have set to short date.

it still pulls through the *beepity beeping* general format (date and time - i only want the date!!!!)

please help - i am at my wits end!

mike c

ps i have done some really fancy stuff before in these graphs so this simple little thing is really driving me nuts

 

[humbleprogrammer]

Have you tried setting the dates format property in the report to mm/dd/yyyy?

Right click date field - choose properties - go to format tab - type mm/dd/yyyy in the format field.

 

[mikecollett]

yes i did that

finally figured a work around

i copied the whole column into excell, made it dd/mm/yy in there and thern copied it back over the old data into access.

messy i know but i won. i refuse to be beaten by a pile of silicon!

mike c