Fixed Format

[tikchye_oldLearner57]

hi

can anybody kindly explain to me what is the meaning of

Format the field to "Fixed" and place the "Decimal" to 2

example:

I did an exercise and the procedure wanted the user to format the result to
a) Format the field to "Fixed"
b) Have a Decimal place of 2


thanks for the explaination

 

[Allen Browne]

It means the field is *displayed* rounded to 2 places after the decimal
point.

The Format property has to do with how the value is displayed, and does not
affect what is actually stored in the field (which could be more places.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[John Vinson]

It means the field is *displayed* rounded to 2 places after the decimal
point.

The Format property has to do with how the value is displayed, and does not
affect what is actually stored in the field (which could be more places.)

Or, if you choose the default Number datatype - Long Integer - it will
have no decimals stored at all, and will be displayed with <number>.00
regardless of how many digits you type after the decimal point.

John W. Vinson[MVP]