ACCESS FEED: RE: [MS_AccessPros] Making a field all CAPS

Senin, 05 September 2011

RE: [MS_AccessPros] Making a field all CAPS

Hi, Crystal

I don't understand it all, either, well. I am using Access 2010.

I have a large database. I have it set up to "show" all caps, I ">" in the
format section of Field Properties. So the database shows all caps, even
though the majority of items were/are initially filled in with all
lowercase. But when I export to create labels, many of them still come out
in lowercase. Is there a separate setting for that.? Is there a way that
sets up the fields in all caps, no matter what I enter or do with them?

I know this is fairly simple for you constant Access users, but I don't use
it all that much. And I cannot figure it out.

Thanks

Don

Description: Description: Frog Signature

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Sunday, September 04, 2011 2:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Making a field all CAPS

Hi Don,

I don't understand what you are asking ... would you please clarify what you
changed, what you are doing, what happens, and what you want to happen
instead? thanks

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Sun, 9/4/11, Don Holstrom wrote:

> Hi, Crystal. I have that set up that
> way now. But when I print, say to
> mailing labels, it can come across as lower case. Most of
> the entries are
> entered in lowercase. Is there some other place I need to
> make a change?
>
>
>
> Description: Description: Frog Signature
>
>
>
> From: Crystal

>
> Hi Don,
>
> Welcome :)
>
> > "so names and addresses would be capped in mailings I
> am
> sending out"
>
> because you want to display caps does not mean text needs
> to be stored that
> way ...
>
> in any control that you want displayed as UPPERCASE, set
> the Format property
> to >
>
> Warm Regards,
> Crystal
>
> Access Basics by Crystal (Bill Mosca's site)
> http://thatlldoit.com
> Free 100-page book that covers essentials in Access
>
> *
> (: have an awesome day :)
> *
>
> --- On Wed, 8/31/11, Don Holstrom wrote:
>
> > I am sorry, I asked this question,
> > probably very simple for someone here,
> > but I was not added to the group right away so did not
> get
> > an answer.
> >
> >
> >
> > How can I make all of certain fields all caps, no
> matter
> > what I typed in? I
> > have a very large database, set up many years ago, and
> I
> > want to make the
> > fields fully capped, so names and addresses would be
> capped
> > in mailings I am
> > sending out.
> >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> MS_Access_Professionals-fullfeatured@yahoogroups.com
<mailto:MS_Access_Professionals-fullfeatured%40yahoogroups.com>
>
>
>

[Non-text portions of this message have been removed]