New at making reports, having problems.
I get the "#Error" in Preview and Print when i do simple formatting to report fields.
Example, I have a report field associated with a date/time field in a table (with a typical date 3/06/2000); I get the "#Error" when i put this code in the report field's Control Source property "=Format([Field]), "yyyy")".
Example 2, I have a report field associated with a number field in a table (with a typical number "0.3"); i get the "#Error" when i put this code in the field's Control Source, "=Format([Field], "0.00").
I first thought the associated table's field datatype had something to do with it, but this is not the problem; is there some kind of "black magic" i have to do to make Access perform?
Thank you!
Llyal
I get the "#Error" in Preview and Print when i do simple formatting to report fields.
Example, I have a report field associated with a date/time field in a table (with a typical date 3/06/2000); I get the "#Error" when i put this code in the report field's Control Source property "=Format([Field]), "yyyy")".
Example 2, I have a report field associated with a number field in a table (with a typical number "0.3"); i get the "#Error" when i put this code in the field's Control Source, "=Format([Field], "0.00").
I first thought the associated table's field datatype had something to do with it, but this is not the problem; is there some kind of "black magic" i have to do to make Access perform?
Thank you!
Llyal