Francis Boundy
|
| Posted: 08/08/2001, 6:01 AM |
|
How can I change the formatting of numerical and/or date fields in CC?
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/08/2001, 6:49 AM |
|
This is done in Form properites/Events/Before show" event , e.g.
fldprice = FormatCurrency(fldprice)
CC automatically creates variables for form/database fields.
They contain field values that you can feel free to change.
"fld" is a standard prefix for cc field variable. For instance
if field name is price then corresponding cc variable is named fldprice.
You can manipulate them through events.
--
Alex
Francis Boundy <fboundy@troyikoda.com> wrote in message
news:9krd5v$el7$1@news.codecharge.com...
> How can I change the formatting of numerical and/or date fields in CC?
>
>
|
|
|
|
Don Oldenburg
|
| Posted: 08/08/2001, 2:25 PM |
|
GREAT -- that works nicely... Except when you have it on an form to
update--Then it has a problem writing it back to the database. I am
assuming we need an opposite event on a "before update" event... something
like formatdecimal or formatnumber? I know it bombed out on formatdecimal,
haven't tried number yet.
Don
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9krg1l$kti$1@news.codecharge.com...
> This is done in Form properites/Events/Before show" event , e.g.
>
> fldprice = FormatCurrency(fldprice)
>
> CC automatically creates variables for form/database fields.
> They contain field values that you can feel free to change.
> "fld" is a standard prefix for cc field variable. For instance
> if field name is price then corresponding cc variable is named fldprice.
> You can manipulate them through events.
>
>
> --
> Alex
>
> Francis Boundy <fboundy@troyikoda.com> wrote in message
>news:9krd5v$el7$1@news.codecharge.com...
> > How can I change the formatting of numerical and/or date fields in CC?
> >
> >
>
>
|
|
|
|
Don Oldenburg
|
| Posted: 08/08/2001, 2:29 PM |
|
formatnumber() sorta worked... it drops the pennies though...
"Don Oldenburg" <don.oldenburg@cacmnet.com> wrote in message
news:9ksaok$dql$1@news.codecharge.com...
> GREAT -- that works nicely... Except when you have it on an form to
> update--Then it has a problem writing it back to the database. I am
> assuming we need an opposite event on a "before update" event...
something
> like formatdecimal or formatnumber? I know it bombed out on
formatdecimal,
> haven't tried number yet.
>
> Don
>
>
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:9krg1l$kti$1@news.codecharge.com...
> > This is done in Form properites/Events/Before show" event , e.g.
> >
> > fldprice = FormatCurrency(fldprice)
> >
> > CC automatically creates variables for form/database fields.
> > They contain field values that you can feel free to change.
> > "fld" is a standard prefix for cc field variable. For instance
> > if field name is price then corresponding cc variable is named fldprice.
> > You can manipulate them through events.
> >
> >
> > --
> > Alex
> >
> > Francis Boundy <fboundy@troyikoda.com> wrote in message
> >news:9krd5v$el7$1@news.codecharge.com...
> > > How can I change the formatting of numerical and/or date fields in CC?
> > >
> > >
> >
> >
>
>
|
|
|
|
|
