Myron: Sure, it's easy. Bring up your form in the designer and click the Tables / Display Format option. It'll display all the tables on your form. Click the + to expand the table you want and display the columns. Click the column you want to apply the format to and pick it from the list. See the print-screen below. Karen
-----Original Message----- From: Myron Finegold <[email protected]> To: rbase-l <[email protected]> Sent: Sat, Mar 30, 2019 1:45 pm Subject: RE: [RBASE-L] - Telephone Number Stored as Text Value in a Table #yiv9955542756 #yiv9955542756 -- _filtered #yiv9955542756 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv9955542756 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv9955542756 #yiv9955542756 p.yiv9955542756MsoNormal, #yiv9955542756 li.yiv9955542756MsoNormal, #yiv9955542756 div.yiv9955542756MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;} #yiv9955542756 a:link, #yiv9955542756 span.yiv9955542756MsoHyperlink {color:blue;text-decoration:underline;} #yiv9955542756 a:visited, #yiv9955542756 span.yiv9955542756MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv9955542756 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;} #yiv9955542756 p.yiv9955542756msonormal0, #yiv9955542756 li.yiv9955542756msonormal0, #yiv9955542756 div.yiv9955542756msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;} #yiv9955542756 p.yiv9955542756msonormal, #yiv9955542756 li.yiv9955542756msonormal, #yiv9955542756 div.yiv9955542756msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;} #yiv9955542756 p.yiv9955542756msochpdefault, #yiv9955542756 li.yiv9955542756msochpdefault, #yiv9955542756 div.yiv9955542756msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;} #yiv9955542756 span.yiv9955542756msohyperlink {} #yiv9955542756 span.yiv9955542756msohyperlinkfollowed {} #yiv9955542756 span.yiv9955542756emailstyle17 {} #yiv9955542756 p.yiv9955542756msonormal1, #yiv9955542756 li.yiv9955542756msonormal1, #yiv9955542756 div.yiv9955542756msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv9955542756 span.yiv9955542756msohyperlink1 {color:#0563C1;text-decoration:underline;} #yiv9955542756 span.yiv9955542756msohyperlinkfollowed1 {color:#954F72;text-decoration:underline;} #yiv9955542756 span.yiv9955542756emailstyle171 {font-family:sans-serif;color:windowtext;font-weight:normal;font-style:normal;text-decoration:none none;} #yiv9955542756 p.yiv9955542756msochpdefault1, #yiv9955542756 li.yiv9955542756msochpdefault1, #yiv9955542756 div.yiv9955542756msochpdefault1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:sans-serif;} #yiv9955542756 span.yiv9955542756EmailStyle29 {font-family:sans-serif;color:#1F497D;} #yiv9955542756 .yiv9955542756MsoChpDefault {font-family:sans-serif;} _filtered #yiv9955542756 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv9955542756 div.yiv9955542756WordSection1 {} #yiv9955542756 Karen,Just getting back to this project.Can you point me in the right direction for -> using the menu option Tables / Display FormatI’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]> To: rbase-l <[email protected]> Sent: Sun, Mar 24, 2019 9:46 am Subject: [RBASE-L] - Telephone Number Stored as Text Value in a TableBackground: 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.-- 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.
