Populate a text box with text based on a score

[benny1983]

I have an access form which is used for auditing purposes.

As part of the process, a score is calculated on the form which displays on the last tab of my form to prompt the user as to who they need to notify based on the score.

For example, a score of more than 80 is a "Low Risk", a score of less than 80 is a "medium risk" and a score of less than 50 is a "high risk".

What I need to do is have a text box that can display the "Low Risk" etc. text based on the outcome of a score which is populated in the txtscore box.

Any ideas on how I can do this?

[twinnyfo]

benny1983,

Try something like this:

Me.txtOverallRisk = IIf(Me.txtScore >= 80, "Low Risk", _
    IIf(Me.txtScore < 50, "High Risk", "Medium Risk"))

Hope this hepps!

[benny1983]

Perfect - Thanks very much!

[twinnyfo]

Glad I could be of some service! Have a great day!

[zmbd]

Another method to this is to use a table.
have your cutoffs in one field with the related text in the second field.
This way instead of having to re-code the form should you need to change the text or the cutoff range(s) you simply alter the table.