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]> 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] <[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]> wrote: > Myron: > > Assuming you may have already been to: > > 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] | +011 (909) 238-9012 c | +011 (909) 912-8678 f > > > ------ Original Message ------ > From: "Myron" <[email protected]> > To: [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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/000001d72b35%2489718be0%249c54a3a0%24%40gmail.com. > -- > 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/emf145d7a9-4527-4ca0-81aa-934ab39cd287%40pathfinder. > > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CABnhDASz%3D4eER7SfKxO%2BJ3DNH1rewhQWAWq91D5%2BUDDxhMR4Pw%40mail.gmail.com. > -- > 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. -- 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/B267F3DE-3ED7-419F-8674-EBDB7475743B%40comcast.net.
