Steve, I think that you have to convert the variable to text for the format to work in the form then convert it back again to update your data if need be. You can use a "text" variable on the form and "real" variable which doesn't get displayed.
Regards, Alastair. ----- Original Message ----- From: "J. Stephen Wills" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 8:23 PM Subject: RE: easy form question > Doug, I replicated what you've observed, then I tried to create a mask, > [999.00]. It didn't work, as it appears that FORMAT MASKS are only > applicable to TEXT types. I don't have an immediate work-around, but it > might require the use of VAR's, Conversion Functions, or possible changing > the Type to NUMERIC ... > > Good luck, > Steve in Memphis > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Doug Daily > > Sent: Tuesday, March 19, 2002 1:36 PM > > To: [EMAIL PROTECTED] > > Subject: easy form question > > > > > > > > I've got a simple form with COLUMN A REAL > > containing data like: 8.00, 9.00, etc. > > > > I cannot get the format mask in the form designer > > to give me 8.00. It shows 8. > > > > I've tried the obvious, and help is no help. > > > > Please help an old man do a simple thing. > > TIA. Rbase 6.5+ > > > > Douglas Daily > > Facilities Services, box 352215 > > 206-221-4357 > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
