Hi Kurt,
A couple of things to look for:
1.) Make sure that the name of the textbox in your report is not FTE %. Open the report in
design view, click on View > Properties to display the properties dialog if it is not already
showing, and select the textbox in question. The name of the textbox is specified on the Other
tab of the properties dialog. It also shows up in the blue title bar of the properties dialog
when you have the control selected. I recommend renaming the textbox to something like txtFTE.
I also recommend not using any special characters, such as the % sign or spaces in the names of
fields, objects (tables, queries, forms, reports, macros, modules, and data access pages) or in
the names of controls on forms, reports and data access pages.
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335
Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp
2.) If the problem is not caused by a circular reference error, as described above, then check
for any missing references in your database:
Solving Problems with Library References (Allen Browne)
http://members.iinet.net.au/~allenbrowne/ser-38.html
and
Access Reference Problems (Doug Steele)
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Tom
_____________________________________
Hey all,
I have double data type information stored within a table field called FTE
%. For example, it may hold 0.075 to indicated 7.5%.
However, i want to times this value by 4, and store it in a percentage type
text box to display within a report. Ive tried =CDbl([FTE %]*4), =[FTE %]*4,
and a few other things, but all i get is #Error. It seems like a simple
problem, but I cant seem to figure this one out. Any help is appreciated,
Kurt
