Use the original text field instead of the calculation field and use data
validation to prohibit changes and display your custom message. Assuming
that the layout you want to limit changes on is called "DataEntry", use the
following for validation by calculation for your text field:
Status (CurrentLayoutName) <> "DataEntry"
Make the validation strict and enter your custom message as desired.
Alternately, if you want only one layout where you CAN change the text
field, validate as follows:
Status (CurrentLayoutName) = "ChangesAllowedLayout"
> The problem is the content of the text field is quite long and needs the
> vertical scroll bar, that is why I need an "active field to display the
> I created the calc field for this purpose as it cannot be modified but
> unfortunately does have an unfriendly error message.
> > You can eliminate the error message by removing access to the field
> > Field Format, uncheck "allow entry into field").
> > > I have a form where for reference purposes I display a text field that
> > > based on a calculation.
> > > It is possible that users will try and type in this field, I want to
> > > suppress the standard error message & replace with my own.
> > > Can this be achieved outside of a script
> > > Regards
> > > Paul Freedman