Karen, Just getting back to this project.
Can you point me in the right direction for -> using the menu option Tables / Display Format I’m lost. Thanks, Myron From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: March 25, 2019 6:55 AM To: [email protected] Subject: Re: [RBASE-L] - Telephone Number Stored as Text Value in a Table Rather than using format masks in the field property itself, I've switched to using the menu option Tables / Display Format. Have you tried that? Karen -----Original Message----- From: Myron Finegold <[email protected] <mailto:[email protected]> > To: rbase-l <[email protected] <mailto:[email protected]> > Sent: Sun, Mar 24, 2019 9:46 am Subject: [RBASE-L] - Telephone Number Stored as Text Value in a Table Background: I have a table that stores a telephone number as a text value. Challenge: How do display the telephone number in a form formatted as 555-698-4567 (or something close)? I’ve used the input format mask as shown below. I’ve tried the format mask (000) 000_0000;1;_ in a DB Edit ‘Input Format Mask’ field – no joy. And I’ve tried !\(999\)\ 000\-0000;0; - again – no joy. And is there a way to format the number is an ‘Enhanced BD Grid Properties’ column field? Then of course the question that begs to be asked is; should I change the table data to reflect the output I need? If so, what is the best way to accomplish this? Myron Finegold -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
