98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access - apostrophes
MS Access - apostrophes
Resolved · Medium Priority · Version 2007
Fri 19 Nov 2010, 10:30Delegate Brian said...
Brian has attended:
Access Introduction course
MS Access - apostrophes
I have an MS Access 2007 that does not like apostrophes, which is a bit of a nuisance for recording organisations that have appostrophes eg. The Prince's Trust, National Farmers' Union. Is there a way of Access accepting them or any reason why my database does not?
Many thanks.
Tue 23 Nov 2010, 15:23Trainer Simon said...
RE: MS Access - apostrophes
Hi Brian,
Thank you for your question and welcome to the forum.
I believe there is an issue with Access 2007 when entering data into a table or form.
What I will do is have a look at a few forums on the net tonight and see if there is a workaround without using VBA code.
Regards
Simon
Fri 15 Apr 2011, 11:13Trainer Rodney said...
RE: MS Access - apostrophes
Hello Brian,
Just a quick update on your question regarding using apostrophes in Access 2007.
After checking a number of forums etc. it appears that this is a problem in certain versions of 2007. My version of Access 2007 is the Enterprise version with all updates including SP2 MSO. I do not experience any issues when entering text into a table or a form using an apostrophe.
Check your version and make sure all updates are installed.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Fri 15 Apr 2011, 11:13Trainer Rodney said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Changing MS Programs Text SizeA handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize. |
