Default Value as Single Quotes

P

Petra

When I try to enter single quotes in a default value as " " ", the single
quotes don't appear in the table column. How can I remedy this so that the
field will accept " Your help is greatly appreciated.
 
S

Sharkbyte

In a table, you can use 2 single quotes and Access accepts them. However,
Default value, on a text field, in a form does not work.

Sharkbyte
 
P

Petra

The table would not accept my 2 single quotes as a default value but I tried
an update query using ["] and although it prompted me for the value, it
appeared to work. Your direction helped me pursue a workaround. Thank
you....
 

Ask a Question

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.

Ask a Question

Top