Converting to upper case ?

[programmerforhire]

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

[Wayne Morgan]

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

[Rick Brandt]

"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

[Peyter]

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

[Peyter]

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