Formatting Text Box

[gdev]

Hi,

Please assist.

amtField is defined in the table as follows
datatype = number
fieldsize = double
format = percent

In the form I want to change the formating of this field for certain records

I have tried the following iif statements in the text box control source:

=iif([name] = "Jane", format[amtfield], "standard"), [amtfield]))

=iif([name] = "Jane", format[original amount], "0000.00"), [original amount]))and made the format property blank

The results are the same #Error for all the records.
What am I doing wrong?

Thanks
Gwen

 

[THWatson]

Gwen
One thing is that you are missing a left bracket following format and before [amtfield].

It should be...
=iif([name] = "Jane", format([amtfield], "standard"), [amtfield])

and there was one too many closing brackets.

Also, you should not use [name] as a field, as this is a reserved word in Access.

Tom