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

Converting to upper case ?

P: n/a
Hello all,
Is there a way to setup an ms-access table so that when I enter
text in the 'datasheet' mode, it will automatically be converted
tp upper case. Or must I use a Form for this?
rex
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You can have the table display what you entered as upper case, but not convert it to upper
case. Also, it is bad form to enter data directly into the table. Tables are for storing
data only, the work should be done elsewhere.

To have the table display the text as upper case type

in the Format box for the field in table design view.

--
Wayne Morgan
Microsoft Access MVP
"programmerforhire" <pr***************@btinternet.com> wrote in message
news:bp**********@sparta.btinternet.com... Hello all,
Is there a way to setup an ms-access table so that when I enter
text in the 'datasheet' mode, it will automatically be converted
tp upper case. Or must I use a Form for this?
rex

Nov 12 '05 #2

P: n/a
"programmerforhire" <pr***************@btinternet.com> wrote in message
news:bp**********@sparta.btinternet.com...
Hello all,
Is there a way to setup an ms-access table so that when I enter
text in the 'datasheet' mode, it will automatically be converted
tp upper case. Or must I use a Form for this?
rex


You have to use a form.

The table could be configured to format the *display* of the text to upper
case or it could be configured to reject the entry of lower case entries,
but it has no events that can be used to automatically do a conversion.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #3

P: n/a

o.k. , it does work and it seems to be exactly what I wanted, but I am
a little confused from what you said. You said that I can't convert to
upper case. I added the ">" sign as you said, and now if I enter some
lower case characters and press 'enter' they do seem to appear as
upper case. So what exactly can't I do, I didn't get this comment ?

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:fH*******************@newssvr31.news.prodigy. com...
You can have the table display what you entered as upper case, but not convert it to upper
case. Also, it is bad form to enter data directly into the table. Tables are for storing
data only, the work should be done elsewhere.

To have the table display the text as upper case type


in the Format box for the field in table design view.

--
Wayne Morgan
Microsoft Access MVP
"programmerforhire" <pr***************@btinternet.com> wrote in message
news:bp**********@sparta.btinternet.com...
Hello all,
Is there a way to setup an ms-access table so that when I enter
text in the 'datasheet' mode, it will automatically be converted
tp upper case. Or must I use a Form for this?
rex


Nov 12 '05 #4

P: n/a
o.k.
I get you, if I remove the ">" it will be lower case again.
Thanks!!

"Peyter" <Pe****@btinternet.com> wrote in message news:bp**********@hercules.btinternet.com...

o.k. , it does work and it seems to be exactly what I wanted, but I am
a little confused from what you said. You said that I can't convert to
upper case. I added the ">" sign as you said, and now if I enter some
lower case characters and press 'enter' they do seem to appear as
upper case. So what exactly can't I do, I didn't get this comment ?

"Wayne Morgan" <co***************************@hotmail.com> wrote in message

news:fH*******************@newssvr31.news.prodigy. com...
You can have the table display what you entered as upper case, but not convert it to upper
case. Also, it is bad form to enter data directly into the table. Tables are for storing
data only, the work should be done elsewhere.

To have the table display the text as upper case type


in the Format box for the field in table design view.

--
Wayne Morgan
Microsoft Access MVP
"programmerforhire" <pr***************@btinternet.com> wrote in message
news:bp**********@sparta.btinternet.com...
Hello all,
Is there a way to setup an ms-access table so that when I enter
text in the 'datasheet' mode, it will automatically be converted
tp upper case. Or must I use a Form for this?
rex



Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.