The AutoCorrect setting in Office is replacing the three separate period
characters with a single ellipsis character which is not a supported character
in an Access control. In your form design you can disable AutoCorrect on your
controls.
Access AutoCorrect is changing 3 periods to an ellipses character (3
closer together dots). Since Access can't actually display the
ellipses, it substitutes a wide | character. However, if you were to
actually print a report, it would show the ellipses character.
You can change this behavior by deleting the change from the
AutoCorrect list, or simply set the form Control's Allow AutoCorrect
property to No.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.