Access 2003 has a bug. It renames my field caption like number

[Guest]

I set my field caption in a query in Access 2003 like this:
2006/07:July 2006 Data
(I want to change the field name from another table to be 2006/07)
,but it change the caption to be 2006/7 !!!!
Where is my zero before 7?
This makes other queries that will link to this query cannot find this field.

I need a service pack to solve this soon !

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...36826d6144&dg=microsoft.public.access.queries

 

[Allen Browne]

Something else is happening behind the scenes here.

If you would like us to try to help you sort this out, switch your query to
SQL View (View menu in query design), and paste the entire SQL statement
here in a reply to this thread.