By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

How to Enter "" in a text box or field

P: n/a
When I try to enter "" in a field or text box, it disappears.

Is it possible to enter a pair of double quotes with no spaces between
the quotes into a field?

Luke
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
The open and closed quotes are interpreted as a zero-length string (i.e. a
string with nothing in it, as distinct from a Null).

Either enter a pair of single quotes, or else programmatically enter the
double-quotes into the field, by opening a recordset and assigning a string,
e.g.:
rs!MyTextField = """"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Luke Chung" <Lu********@yahoo.com> wrote in message
news:73**************************@posting.google.c om...
When I try to enter "" in a field or text box, it disappears.

Is it possible to enter a pair of double quotes with no spaces between
the quotes into a field?

Luke

Nov 13 '05 #2

P: n/a
Hi Allen,

I should have been more clear. Yes, I know how to add it
programmatically. The question is how would end users put in double
quotes if they needed it in a field or text box? Thanks.

Luke

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
The open and closed quotes are interpreted as a zero-length string (i.e. a
string with nothing in it, as distinct from a Null).

Either enter a pair of single quotes, or else programmatically enter the
double-quotes into the field, by opening a recordset and assigning a string,
e.g.:
rs!MyTextField = """"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Luke Chung" <Lu********@yahoo.com> wrote in message
news:73**************************@posting.google.c om...
When I try to enter "" in a field or text box, it disappears.

Is it possible to enter a pair of double quotes with no spaces between
the quotes into a field?

Luke

Nov 13 '05 #3

P: n/a
They can't unless you provide a programmatic approach for them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Luke Chung" <Lu********@yahoo.com> wrote in message
news:73**************************@posting.google.c om...
Hi Allen,

I should have been more clear. Yes, I know how to add it
programmatically. The question is how would end users put in double
quotes if they needed it in a field or text box? Thanks.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.