How to Prevent Access/Word Merge from converting 2-68 to 2/1/1968

  • Thread starter Thread starter Glockemalland
  • Start date Start date
G

Glockemalland

I am using a merge routine from Getz et al to send data from an Access
(2002) form to a Word template.
During the merge, a field containging the text "2-68" is converted to the
date "2/1/1968" when inserted to the
Word document. I've looked at AutoCorrect in both Access and Word, but
cannot find where to turn this
"feature" off.

Any ideas??



TIA,

John McKee
 
You sure that the field actually does have the text 2-68?

Perhaps the field has some formatting.

If that is just a standard text field, then I don't think it should get
converted.

On the other hand, if it is a date field, then I would base your
export/merge on a query, and you can use the format command to force the
format to anything you want, and word should leave it as is.

So, in your query, try:

qD:format([dtTheDate],"mm-yy")
 
Thanks for the prompt help, Albert.

The field containing the data is an unbound text box that is filled on the
forms OnCurrent event.
Checking the Format properties, I see why what's happening is happening. If
it "looks" like a date,
then Access figures it "is" a date and converts it on-the-fly.

Changing the field to a label solved the problem.

Thanks again,


John
 
Back
Top