 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2007Personal information formating??
Good Morning, I have a report with several phone numbers in it; what I would like to be able to do I format the phone number to ***-***-1234 when printed so when these reports get distrubuted the wrong people don't get ahold of this personal information. Thanks, Ron One way would be to add an unbound text field to the report (instead of the bound phone field) and put the following in it's source... ="***-***-" & Right([PhoneNumber],4) You, of course, would replace "PhoneNumber" with the name of your field. You may want to wrap the entire statement in a "IsNull" type of statement so that you don't get asterisks if there is no phone number for a given record.  SignatureRick B > Good Morning, > [quoted text clipped - 6 lines] > > Ron > One way would be to add an unbound text field to the report (instead of the > bound phone field) and put the following in it's source... [quoted text clipped - 19 lines] > > > Ron- Hide quoted text -- Show quoted text - I tried this one and for some reason the report did not like it, it just displayed the expression... Post what you put in the source for your control. SignatureRick B >> One way would be to add an unbound text field to the report (instead of >> the [quoted text clipped - 25 lines] > I tried this one and for some reason the report did not like it, it > just displayed the expression... > Post what you put in the source for your control. > [quoted text clipped - 30 lines] > > I tried this one and for some reason the report did not like it, it > > just displayed the expression...- Hide quoted text -- Show quoted text - Thanks for your help -- I got through some red tape and we have decided that we are going to display the full phone number after all. Thank you again, your help is really appreciated. Ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.