
Auto-calculate entered value.
You can't enter data into a calculation field nor can you reference the same
field in your calculation. Calculation fields as just that, fields that
perform a calculation on another field.
You will need to create another field "text" or "number". Probably "number"
for your example below. Then in your calculation field use the field that
you just created and Round(YourField, 0)
If you want it to appear as ONE field on the layout. Place both fields on
the layout. Make the Calculation field to not allow entry and also make the
field a color by selecting the color palette from the status bar on the left
side of the window. Make both fields the same size. Place the calculation
field on top of the entry field and select move to front from the Arrange
menu. Now select Set alignment form the Arrange menu. Select both center
values and the Ok. Enter browse mode, put you cursor in the field enter a
value. When you exit the field you should see the desired effect. Good luck.
--
Michael Stout
http://www.fmpdev.com/
Quote:
> Hi,
> Does anybody know a way to calculate on a value you enter in a field, and
> then when you press Enter (or TAB) FMP5.0 will calculate on it an set the
> value of that field?
> For instance if I want only INT values I want to be able to enter any value
> (e.g. 12.56) and that FMP set the value "13" in that specific field, without
> the need of another calculation-field?
> I tried, but got circular-errors in the calculation.
> Anybody?
> thanks