terpsichore
asked on
easy one - display if Newrecord
Dear experts -
This should be trivial, but it is stumping me - I simply want to display the word "NEW" in a text box on a form if it is a new record.
I tried making the control source of the field:
=IIf(Form.newrecord=True," NEW","")
But it keeps adding brackets and doesn't work.
Any idea?
Thanks!
This should be trivial, but it is stumping me - I simply want to display the word "NEW" in a text box on a form if it is a new record.
I tried making the control source of the field:
=IIf(Form.newrecord=True,"
But it keeps adding brackets and doesn't work.
Any idea?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER