Hi Teelee ??
Sorry for not getting back to you I thought this thread was finished.
You have a number of basic choices that don't require any great knowledge of
how access works and it depends on what you want to do as to which one you
use.
If you want to change a number that you have inserted into a box into a
percentage you can use AfterUpdate
Right click the box (in design view) and open properties and ensure that the
format is set to Percentage and then click theEvent column. On the
AfterUpdate section click the ... on the right and click Code builder and
insert this code
Private Sub NameOfBox_AfterUpdate()
NameOfBox = NameOfBox / 100
End Sub
An other method you could use would NOT be to change the actual data but
refer to it in an unbound box.
To do this creat a new box (in design view) again open Properties and in the
Data section insert this into the ControlSource section
[NameOfBox]/100
For both options you would need to change NameOfBox to the one you have used
on your form. If you are creating a new box to find/change the name of this
box click properties and look at the top of the "Other" column.
Hope all this makes sense
--
Wayne
teelee said:
Can you tell me please on where on enter this info. Do I click on the ...
button and enter it as an expression builder?
Wayne-in-Manchester said:
You shouldn't really try and store the results of formulas in a table so use
it in a report or on a form. You only need to the either see the result on a
form or in a report so only have it when you actually need it.
Refer to it using an unbound field (I have called the field containing the
number you want to work with PercentFieild)
[PercentField]/100 and thats it (use this as the field's control source)
Hope this helps
--
Wayne
If you feel this answer has been useful please check the "was this post
helpful" so I get some feedback. Thanks.
teelee said:
Where do I enter this info?
:
([FieldName]/100) then format as percentage
--
Wayne
If you feel this answer has been useful please check the "was this post
helpful" so I get some feedback. Thanks.
:
Does anyone know how to use the percent in the table? I have a table that has
a field for a percent, when I enter the number it sould be a percent, in
which it does the only thing is it has more numbers then I need for example I
enter 25 and the field shows 2500%.
