Tony, >From the top menu bar select tables (the main menu bar not the form designer >one. Select display format apply the format to your column Tried that too. The only format options I have would be to format columns that are ‘date and ‘integer’ not text. So, the question becomes: Is there a way to add a text column to the drop down? Then can the column data field be formatted as a phone number? Myron From: [email protected] <[email protected]> On Behalf Of Tony Luck Sent: April 6, 2021 6:07 PM To: [email protected] Subject: Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid Myron, Open your form in the form designed. From the top menu bar select tables (the main menu bar not the form designer one. Select display format apply the format to your column the format will apply to the column in the grid when you display data On Wed, Apr 7, 2021 at 10:43 AM Bruce Chitiea <[email protected] <mailto:[email protected]> > wrote: Myron: Assuming you may have already been to: rbase.com/support/rsyntax/rbgx5 <http://rbase.com/support/rsyntax/rbgx5> Type "mask" into the search control. The first item throws up "Using Format Masks in Forms." You'll find an example within DB Edit Properties. May be a short leap to the Enhanced DB Grid. Best, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA [email protected] <mailto:[email protected]> | +011 (909) 238-9012 c | +011 (909) 912-8678 f ------ Original Message ------ From: "Myron" <[email protected] <mailto:[email protected]> > To: [email protected] <mailto:[email protected]> Sent: 4/6/2021 3:38:15 PM Subject: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid I am using an Enhanced DB Grid in a form One of the columns holds phone numbers in a text format So, it looks like 6233226333 How do I apply a phone number format to the column? Something like: !\(999\)\ 000\-0000;0; or anything that works Stumped. Thanks. Myron Finegold, Arizona -- 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]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000001d72b35%2489718be0%249c54a3a0%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/000001d72b35%2489718be0%249c54a3a0%24%40gmail.com?utm_medium=email&utm_source=footer> . -- 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]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emf145d7a9-4527-4ca0-81aa-934ab39cd287%40pathfinder <https://groups.google.com/d/msgid/rbase-l/emf145d7a9-4527-4ca0-81aa-934ab39cd287%40pathfinder?utm_medium=email&utm_source=footer> .
-- Regards Tony -- 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]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDASz%3D4eER7SfKxO%2BJ3DNH1rewhQWAWq91D5%2BUDDxhMR4Pw%40mail.gmail.com <https://groups.google.com/d/msgid/rbase-l/CABnhDASz%3D4eER7SfKxO%2BJ3DNH1rewhQWAWq91D5%2BUDDxhMR4Pw%40mail.gmail.com?utm_medium=email&utm_source=footer> . -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/00e801d72bc7%243664f030%24a32ed090%24%40gmail.com.
