[mso] Re: Access Text String Format
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Mon, 29 Apr 2002 08:47:45 -0400
That did it Ken. Oddly, when I typed it in, kept getting syntax error then
copied EXACTLY same thing from Access Help and it worked! I made screen
shots to compare and they are exactly the same. Well, problem solved for
now but weird. Thanks. /gl
-----Original Message-----
From: Ken Grubb [mailto:KGRUBB@xxxxxxxxxxxx]
Sent: Saturday, April 27, 2002 1:31 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Text String Format
Glenda Wells asked:
> Is there any way to format a field within a text string?
> I want to use a social security field within a string.
Another solution:
Format([SSN],"@@@-@@-@@@@")
Ken Grubb
Burlington, NC
*************************************************************
PLEASE READ!!!!
This is not S*P*A*M! You are receiving this mail because you either
subscribed to mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not
put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the
caps prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
This is not S*P*A*M! You are receiving this mail because you either subscribed
to mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
