Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / October 2006

Tip: Looking for answers? Try searching our database.

Duplicate Record and Phone Number Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Angie M. - 31 Oct 2006 04:44 GMT
Hi,

I have a form with a phone number field.  Instead of using formats or input
masks in the table I just formatted the field on the form with a format of
"@@@-@@@-@@@@".  Now when I use the Duplicate command button on the form, the
new record has double dashes such as "615-4-42--4111.  When I click in the
field the extra dashes go away, when I click off the field they reappear.  
I've tried everything - removing the format, putting the format in the field
in the table instead, using an input mask, etc.  Any ideas?  Thanks
Angie M. - 31 Oct 2006 06:13 GMT
I figured it out - got rid of the format and added the Input Mask in the
form, not the table.  thanks

> Hi,
>
[quoted text clipped - 5 lines]
> I've tried everything - removing the format, putting the format in the field
> in the table instead, using an input mask, etc.  Any ideas?  Thanks
 
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.