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.
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
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
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.
