Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access form date appears in Chinese

Posted on 2011-03-08
7
Medium Priority
?
393 Views
Last Modified: 2013-11-28
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
Comment
Question by:rick_nicholsfarms_com
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 85
ID: 35074535
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
 

Author Comment

by:rick_nicholsfarms_com
ID: 35074752
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
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 35159207
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!

 

Accepted Solution

by:
rick_nicholsfarms_com earned 0 total points
ID: 35159515
FIXED IT      you have to use  CDATE(......)  around your expression.  Thanks folks
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 35184552
Is the control bound to a Date field?  If so, just use the field itself in the query (if possible)
0
 
LVL 85
ID: 35197571
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
 

Author Closing Comment

by:rick_nicholsfarms_com
ID: 35221284
i actually got the answer from a local tech
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question