Envelopes ... need all caps
- From: "ConversionError" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Apr 2005 11:40:37 -0700
I'm part of a team that's converting some inherited
databases from Access97 to 2003. All of our envelopes must
have all caps in the addresses for our mail center to
process them. In Access97, we simply dropped the ">" in
the report format with a ton of logical stuff in the
mailing address text box. This is a database used to record
data collected in the field, so this somewhat heinous logic
has taken care of changed information in the past. Now, if
we take out the ">", it will insert the correct
information; however, I cannot figure out how to make it
capitalize. Is there an easy way?
Ex.
=[mailname] & Chr$(13) & Chr$(10) & "ATTN: " &
[contactmr/dr/ms] & " " & [contactfirstname] & " " &
[contactlastname] & Chr$(13) & Chr$(10) & [contacttitle] &
Chr$(13) & Chr$(10) &
IIf(IsNull([contactaddress1]),([mailaddress1] & Chr$(13) &
Chr$(10) & IIf(IsNull([mailaddress2])," ",[Mailaddress2] &
Chr$(13) & Chr$(10)) & [mailcity] & " " & [MailState] & "
" & [MailZip]),[contactaddress1] & Chr$(13) & Chr$(10) &
IIf(IsNull([contactaddress2])," ",[contactaddress2] &
Chr$(13) & Chr$(10)) & [contactcity] & " " & [contactste] &
" " & [contactzip])
Thanks,
CE
.
- Follow-Ups:
- Re: Envelopes ... need all caps
- From: fredg
- Re: Envelopes ... need all caps
- Prev by Date: Re: conditional formatting based upon "limits" in a table?
- Next by Date: Re: how to get query result into textbox on report..
- Previous by thread: How do I get data from different queries in one report in Access?
- Next by thread: Re: Envelopes ... need all caps
- Index(es):
Relevant Pages
|
