APEX

Is it possible to dynamically change numeric format mask?

A lot of this is "looking into possibilities" so I don't have a specific example that I can put on the shared site.

Essentially, what we're looking at doing is being able to dynamically display some information containing 1 to XX columns. The information will come from a table in the database and will indicate the type of field, including if it's numeric whether its a regular number or money field.

Now, I can do the to_char to format that, but I want is for the use to be able to enter data in these fields (overriding what's there) which will then update the table when they apply changes. At the same time, I want to use the APEXLib Framework to have it do the verification, put the $ on, etc.

Of course, I've been going back and forth on how to actually display all this...be it a report, form, or dynamic SQL.

Thoughts?

Thanks as always,
Chad