Buddy, I ‘get’ the phone numbers each month from an outside source as text and not always formatted the same. So, the skeepi function is used to strip out all the unwanted characters, the ( ) - . Now the challenge is to reformat the data as a phone number. Reading you correctly would mean I should turn the column into an integer and then use the built-in format. Worth a try. Thank you. Stay well. Myron From: [email protected] <[email protected]> On Behalf Of Buddy Walker Sent: April 7, 2021 9:19 AM To: [email protected] Subject: Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid Myron Maybe I’m missing something but is there a reason you want the format saved in the table. Since it is easy to format in forms and reports. I would store the number as integer. This way only numbers would be stored. Buddy Sent from my iPhone
On Apr 7, 2021, at 12:01 PM, Myron <[email protected] <mailto:[email protected]> > wrote: 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] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of Tony Luck Sent: April 6, 2021 6:07 PM To: [email protected] <mailto:[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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/00e801d72bc7%243664f030%24a32ed090%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/00e801d72bc7%243664f030%24a32ed090%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/B267F3DE-3ED7-419F-8674-EBDB7475743B%40comcast.net <https://groups.google.com/d/msgid/rbase-l/B267F3DE-3ED7-419F-8674-EBDB7475743B%40comcast.net?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/006a01d72bd7%24d5127a80%247f376f80%24%40gmail.com.
