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]>
To: rbase-l <[email protected]>
Sent: Sun, Mar 24, 2019 9:46 am
Subject: [RBASE-L] - Telephone Number Stored as Text Value in a Table
<!-- #yiv1432737460 _filtered #yiv1432737460 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1432737460
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv1432737460
#yiv1432737460 p.yiv1432737460MsoNormal, #yiv1432737460
li.yiv1432737460MsoNormal, #yiv1432737460 div.yiv1432737460MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;} #yiv1432737460 a:link, #yiv1432737460
span.yiv1432737460MsoHyperlink {color:#0563C1;text-decoration:underline;}
#yiv1432737460 a:visited, #yiv1432737460 span.yiv1432737460MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;} #yiv1432737460
span.yiv1432737460EmailStyle17 {font-family:"Calibri",
sans-serif;color:windowtext;font-weight:normal;font-style:normal;text-decoration:none
none;} #yiv1432737460 .yiv1432737460MsoChpDefault {font-family:"Calibri",
sans-serif;} _filtered #yiv1432737460 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv1432737460 div.yiv1432737460WordSection1 {} -->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].
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.
