469,610 Members | 2,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Converting to upper case ?

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
4 12786
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
"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

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

Similar topics

2 posts views Thread by ToddT | last post: by
2 posts views Thread by kevin | last post: by
10 posts views Thread by jose.jeria | last post: by
3 posts views Thread by Brian Conway | last post: by
8 posts views Thread by Brian Conway | last post: by
6 posts views Thread by Manish | last post: by
5 posts views Thread by Nelson | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.