• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Access form date appears in Chinese

I created a text box on my menu form, default value = Now(), I open the menu and it does infact display     3/8/2011 1:30:00 AM     then i create a query with a column     expr1:[forms]![frmMenu]![txtDate]      when i open the query, it shows Chinese characters in that column,  I see this happening in dozens of other places that have been working fine up until now
0
rick_nicholsfarms_com
Asked:
rick_nicholsfarms_com
  • 3
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you performed maintenance on the database?

First, make a backup, then Compact the database. You didn't mention what version of Access you're using, but:

Access 2003 and earlier: Click Tools - Database Utilities - Compact
Access 2007: Office button - Manage - Compact
Access 2010: File tab - Compact

You might also try importing the database into a new, blank container.

If that doesn't work, then please post a screenshot of the issue you're having.
0
 
rick_nicholsfarms_comAuthor Commented:
I am using Access 2003.   I did do a Compact and Repair, I also tried importing the form and query to a new blank DB.  Its still happening on both our Windows 7 and Windows XP PCs.
Untitled.jpg
0
 
Helen FeddemaCommented:
In my experience, when you start seeing Chinese characters in a table, it is badly corrupted, and you will probably have to go back to an earlier version.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
rick_nicholsfarms_comAuthor Commented:
FIXED IT      you have to use  CDATE(......)  around your expression.  Thanks folks
0
 
Helen FeddemaCommented:
Is the control bound to a Date field?  If so, just use the field itself in the query (if possible)
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
CDate will NOT fix this issue. It may have masked the issue you have, but CDate does nothing more than convert the string to a Date datatype.
0
 
rick_nicholsfarms_comAuthor Commented:
i actually got the answer from a local tech
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now