OraFAQ Forum: Forms » Set Format

Home » Developer & Programmer » Forms » Set Format_mask for a variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Set Format_mask for a variable [message #172207]

Mon, 15 May 2006 08:47

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii all

i want to set a mask formating for a variable in my form

i cannot use

set_item_property (BALANCE,FORAMT_MASK,'99.99');

because 'balance' is not an item in my form
it is only a variable that is sent to an excel sheet
and i want to sent it formated

Report message to a moderator

Re: Set Format_mask for a variable [message #172208 is a reply to message #172207]

Mon, 15 May 2006 08:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

A number is a number. It is the format in the spreadsheet that gives it 'shape'. Search this forum for 'excel' or 'spreadsheet'. There are examples of populating data in Excel spreadsheets. I also think one of them sets a format.

David

Report message to a moderator