Hi Don,
> "But when I export to create labels"
that is because FORMAT only changes the way that data looks, not what it is. When you export data, you need to actually change the data itself.
on the grid of the query to export, in the field cell:
NewFieldname: UCase( nz([fieldname],"") )
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Mon, 9/5/11, Don Holstrom <don@holstrom.com> wrote:
> From: Don Holstrom <don@holstrom.com>
> Subject: RE: [MS_AccessPros] Making a field all CAPS
> To: MS_Access_Professionals@yahoogroups.com
> Date: Monday, September 5, 2011, 7:31 AM
> 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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
>
>
Tidak ada komentar:
Posting Komentar