Access 2007 12-17-09

I am building a contact data base for my church. How do I get the phone field 
to automatically format like this (xxx) xxx-xxxx when the numbers are typed 
in the cell?
Thank You
12/17/2009 1:51:02 PM
access 16762 articles. 3 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 2

In the form design view select the phone control and open the properties 
dialog.  Goto the Data tab and use the Input Mask to define the format you 
wish to use.  If you click on the ... to the right hand side on the property 
you will get another dialog where there are predefined input mask or you can 
define your own.

For instance, I use 

!\(999") "000\-0000;0;_

to format my telephone controls, but you may wish a different format 
depending on your exact needs.  You can look up Input Mask in the help or 
even on google to gets tons more information on the subject.
Hope this helps,

Daniel Pineault
For Access Tips and Examples:
Please rate this post using the vote buttons if it was helpful.

"Bishop" wrote:

> I am building a contact data base for my church. How do I get the phone field 
> to automatically format like this (xxx) xxx-xxxx when the numbers are typed 
> in the cell?
> -- 
> Thank You
12/17/2009 2:35:02 PM

Similar Artilces:

Business Portal should allow me to access different dynamics.set
I use GP to manage several different companies. Each company had different check formats. It is fairly simple to set up different report.dic files for different companies if you are using terminal services directly or are using GP from your desktop, however, if you are running thru Business Portal you are only allowed to point to one dynamics.set file. It would be great if you could set up BP so that it would point to different dynamics.set files for differnt companies. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most ...

Access vs Visual Basic (Language Issue)
I have database in access and made some interface for populating database, cause we needed something fast to do it and had no time to make it in vb. And I had Serbian (Latin) characters entered into this dabase and showing in Access forms well. But now when I need to make program in VB, ADO fields does not return me Serbian (Latin) specific characters it returns me English (US) replacements. I do have installed Serbian (Latin) on system but Default language is English (US). (and I must not switch default language to Serbian (Latin)) hopeless for now I am sure that something in ado is done ...

error message 12-03-09
Every time I try to open a url from an email message, I get an error message telling me that window can not open it. But if I click off the error message and try to open the url again, it will open. Any body know why?? Thanks Actually the error message states that "Windows can not find the URL." thanks, dljfnp "dljfnp" wrote: > Every time I try to open a url from an email message, I get an error message > telling me that window can not open it. But if I click off the error message > and try to open the url again, it will open. Any body know why?? ...

still able to workd in Access 2007
Hello, I am developping our church membership database using Access 2002 in my laptop. I plan to convert it to access97 then I create MDE using Access 97 in my othercomputer. My question is, with all VBA that I created, Is there any possiblity that it can not work in Access 97?, otherwise I just make MDE access2000. Thanks for any idea provided -- H. Frank Situmorang You may be able to save it as an Access 97 MDB. If you plan to, do this before you split. Of course, it won't work if you used any of the things that were not in Access 97, e.g. AllForms collection, OpenReport in dia...

Outlook 2007: No copy and paste with CTRL+INS
Hi! As a left handed user I always use CTRL+INS and SHIFT+INS for copy and paste. MS seems to have deactivated this shortcut in Outlook 2007 (which is very annoying if you are left handed). Is there a way to enable this shortcut again? Regards, Achim Achim Becker, you wrote on Wed, 08 Apr 2009 11:21:07 +0200: > CTRL+INS and SHIFT+INS What does "INS" mean? The shortcuts are CTRL+C (copy) and CTRL+V (paste). Or I do not understand? X'Posted to: microsoft.public.outlook,microsoft.public.outlook.general -- Best Regards Christian Goeller MVP - MS Outlook http://www.o...

Word 2007 Headings: whole line or nothing
I had a large technical document I worked on in Word 2003 where the beginning of each section had a species name and other information (codes, authorities, etc.). I was able to select just one portion of the line (the name) and assign it to a heading, and have it appear in the Table of Contents. After importing the file in Word 2007, it will not show that text in the ToC, and if I go to reselect it as a Heading style, it will not allow me to select just one part of the line--either the whole line is part of the Heading, or none of it. Doesn't matter if I save the document in ...

Outlook 2007 totally disabled
1. MS Office 2000 installed on Vista OS. All email accounts, including Hotmail, operable using Outlook, with Outlook Connector. 2. Installed Enterprise 2007 and uninstalled (apparently not all of) Office 2000. 3. Accessing Outlook 2007 from desktop icon produces error "The Add-in "Outlook Connector Extenions" (msncon32.dll) cannot be loaded and has been disabled by Outlook. Please contact Add-in manufacturer for an update. If no update available uninstall the Add-in". 4. Now Outlook 2007 is totally inoperable, but displays previous Inbox emails, but Se...

Chart Skew in 2007
In 2001 and 2003 versions of Excel I could click on a slice of a pie chart (or multiples by holding ctrl) and skew it. I could for instance take a pie piece and make the outside "taller" than the middle. However I can't seem to do that with 2007. Can anyone help me? This effect was very useful in my presentations as it made the charts really pop. What do you mean, "skew" a pie slice, or make the outside "taller"? You can single click twice to select a pie chart, then drag that slice away from the center of the pie. You could not select multiples with th...

import Exchange 2003 information stores into newly set up Exchange 2007
Exchange 2007 set up and running beautifully. But I had a previous Exchange 2003 that was running as part of SBS on a different domain that I would like to import private and public information stores into the new Exchange 2007 environment. I have the 2003 information stores copied to a backup directory on the new Exchange server. Any ideas? I thought there might be some command line utility for such. Thanks very much! Don On Sun, 17 Dec 2006 13:34:59 -0600, "dbj" <> wrote: >Exchange 2007 set up and running beautifully. But I had a previou...

Converting Access 2000 table to Access 97
How do you link an Access 2000 table to an Access 97 database? Thanks for your time. ...

Just instaled on new machine Word 2007 and Outlook 2007. Each time i look to open outlook it come up with a request for f drive data pst. I made a copy onto system of data transfered from old xp. When going to open that file in the system it is rejected with a message saying "the set of folderes cannot be opened" and shuts down Outlook. -- Georges and Lyn Check that the copy you transferred to Windows 7 isn't marked Read Only. If so, remove the checkmark and click OK. Then open Outlook again. If you still have an issue, please run scanpst.exe against the PST file ...

access to pdf to powerpoint
I want to create a report in Access, export to pdf and import into powerpoint. I can export from Access to pdf ok but want to import to powerpoint and create one slide for each page of the pdf report. I haven't received a response on the Powerpoint discussion group. Do I need to make each pdf just one page? Is there a way to do that in Access? Thanks This is my favorite .ppt site. Maybe you can find something there. -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "CC"...

Should I upgrade to a newer version of Access?
Hi All, I currently use Access 2002. I have one application I've written that I sell, and one or two others in development. Though I'm not currently doing so, I'd like to start playing with web applications. While this question might be a little vague, I'm wondering if there are compelling reasons for me to upgrade to a new version of Access. I've been to the Microsoft site. I gather that they'd LOVE me to upgrade. I'm hoping I can get an opinion or two from actual users of the various versions. I expect to get more good information without q...

Outlook 2007 issues
I have installed Office 2007. While in Outlook in some email I have a red bar that keeps going from left to right and the top of the email. I also keep geeting an error that says: "Outlook could not create the work file. Check the temp environment variable." Anytime I try to open an email this message comes up. This message also comes up when I try to open word. Now I had Office 2003 installed before and it was running fine. Is this a known issue? I could not locate it on MS web-site. How can I fix this? Thanks, CEV CEV <> wrote: > I have ins...

OFFICE 2007 installation with NO DISC
how can / where can i download officre onto my netbook using the product key of the version i boght have lost the disc How to replace Microsoft software or hardware, order service packs, and replace product manuals;[ln];326246 Tim wrote: > how can / where can i download officre onto my netbook using the product key > of the version i boght have lost the disc "Tim" <> wrote in message > how can / where can ...

OUTLOOK (2007) won't send to multiple addresses
Vista. I'm trying to "reply all" to a group of about 40 addresses. The message gets stuck in the outbox. If I "reply all" but substitute a single email address, it goes with no problem. Is there some kind of limit, restriction or otherwise that affects messages? Thank you. The limit is set by your ISP/Mail Server. Contact them to find out what your limit is. "its_my_dime" <> wrote in message news:urv87qDcJHA.4124@TK2MSFTNGP06.phx.gbl... : Vista. : : I'm trying to "reply all" to a group of about 40 address...

open access form from outlook
I am sending the user an email from my form. Is there a way to pass something to the user through the email so they can click on it to open the form on the correct record? I have tried a few things that work on the run command, but when I use outlook it does not work. I'm not sure if it is virus protection stopping it or what. Thank you in advance for any help you can provide. Cynthia No, that will not work. You Access application which contains the form and the data is running on your computer. -- Dave Hargis, Microsoft Access MVP "Cynthia" wrote: > I am sendin...

Using Access for SQL data tweaking
Hi, I read the thread about the dangers of going in with Microsoft Access and using the grid/queries format to modify RMS data. I see that it can be done if you are willing to take the risks of bypassing the verification checks performed by RMS. However, what I don't quite get is how to make Access talk to the SQL database to begin with! I am using SQL Server Express 2005 (only works with the latest hotfix for RMS; that's an alligator I think is already licked) and Access 97. All I'm aware of to try is just directly attempting to open the .mdb with Access, but it doesn&#...

Is there a Cheat Sheet for Access Requirements Available?
Hi, Is there some type of cheat sheet available that gives the various combination of permissions needed on CreateFile vs Object Permissions for various things. In other words, can an app using CreateFile open a device using GENERIC_READ and still send DeviceIoControl commands to it? In order for a CreateFile to use GENERIC_READ or GENERIC_WRITE what are the object permission requirements (allow write access/read access/ control/ etc..). ?? TIA!! Hi David, AFAIK there is no such sheet, but good sources are always these documents: [CreateFile Function] http://ms...

Querys not updated
Recently we updated the databases from Access 97 to 2003. The querys were not updated and the ones that are needed to perform mail merge are not retreiving the data. The tables and the data is there, but is not being read. Is there a methos to update the querys ? The OS is XP for the clients and W 2000 for the server. Thanks in advance Alfredo -- Message posted via On Wed, 12 Mar 2008 04:27:13 GMT, "alfredoag via" <u11123@uwe> wrote: >Recently we updated the dat...

Problem with Exchange 2007 and Entourage 2008 connection
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: Exchange Hello, <br><br>I was wondering if anyone has seen this issue, or knows the resolution to the problem I'm having. <br><br>We have resently upgrade our Exchange server from 2003 to 2007. Before the upgrade my two mac users were using Entourage 2008 over ssl with no problems. After an upgrade they have lost connectivity and can no longer connect Entourage 2008 to their Exchagne 2007 mailbox. <br><br>I have tried everything that is my knowledge and...

Hyperlink to bookmark in Word 2007
I can hyperlink to a bookmark in a Word document if the document is opened in Word 2003, where the link is of the form: http://server/mysite/docs/mydoc.doc#mybookmark However, in Word 2007, the document is opened at its top; the bookmark is ignored. Could anyone confirm whether this is a known problem with Word 2007? I have seen another instance reported: but supporting evidence would be helpful. Thanks. In a quick test, hyperlinking to a particular bookmark seems to work f...

syncing mail stores between 2 Exchange 2007 servers?
We have a main location with an AD/file server running Windows Server 2003 R2 32-bit. We also have an Exchange server here running Windows Server 2003 R2 64-bit and Exchange 2007 Standard SP2. We have a second location with a backup AD/file server running Windows Server 2008 R2 64-bit. We also have an Exchange server running Windows Server 2008 64-bit and Exchange 2007 Standard SP2. The purpose of this second location is strictly to serve as a backup - if a disaster occurs, the plan would be to restore our file shares and Exchange database to these servers at our second loc...

not able to receive receipts in outlook 2007
hi, i been having a problem over the past week that i am no longer receiving read and delivery receipts. i went to options then to e-mail options and then to tracking options. i saw that both read and delivery receipts were checked. i unchecked them. then i closed out the program and opened it again. then i rechecked read and delivery receipts. unfortunately that did not resolve my issue. what can i do to resolve this problem. thanks dave What type of email acct? The usual cause of missing receipts is your mail server's antispam program treating them as spam but if exchange, they ...

Formula's not calculatin in Excel 2007
Hi, Earlier if i had formulae in excel , if i entered any value(for ex a10 was sum of a1 to a8 and if i entered any value in a4 automatically a10 used to show 4 ie) the resulting value cell used to automatically calculate as usual. But now i am observing from few days that regardless of any excel i open , if i enter any value where formula exist the values are not getting automatically calculated. I have to manually go to the cell which has formula and when i double click and press enter the formula works. This is happening for any sheet i open Is it because that any settings have c...