I have an access form with, for the purpose of this question, has two fields:
"Action" and "Action Type"
"Action" is a text field. It is just the name of any action.
"Action Type" is a number field. It defines an action as being a task or a meeting. 1 for task, 2 for meeting.
When the "Action Type" is 2, I want whatever is in the "Action" field preceded by a *.
Example: Worked on this database till my eyes popped out. (Action Type 1)
*Meeting about how I cry too much when working on databases (Action Type 2)
How should I do this? And ideas?