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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kraiwit - 25 Aug 2006 04:21 GMT

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 !

Reply to this Message

Allen Browne - 25 Aug 2006 05:00 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I set my field caption in a query in Access 2003 like this:
> 2006/07:July 2006 Data
[quoted text clipped - 15 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=e17326c6-d156-4
8e9-81d8-5d36826d6144&dg=microsoft.public.access.queries

Reply to this Message