Format() function returning #Name 1

[SiJP]

I have an Access (97) database that is used by two users. One user has Win2k, the other has WinXP. Both users have Access 97.

Both users open the same report. One of the (unbound) fields on the report is as follows:

=[TimeSpent] & " (" & Format([TimeSpent]/1440,"hh:nn") & ")"

On the Windows 2000 PC, the following result is displayed:
- 360 (06:00)

On the Windows XP PC, the following result is displayed:
- #Name

Why is this?

TIA

------------------------
Hit any User to continue

 

[KenReay]

Hi

Is the control by chance called TimeSpent if yes, change its name

altrnatively, I think I have seen something on the MS KB site about this, I thought an error message was produced something like "Function not allowed", sorry cannot remeber KB number

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[SiJP]

Hi ken.. no, the control is unbound, and named 'text118'

I'll have a butchers on the MS web site... thanks

------------------------
Hit any User to continue

 

[Molby]

Try checking for missing references in a module. I had the same thing when I switched over to XP that it didn't recognise Format, take out the missing reference and it will work okay

 

[SiJP]

Yeah weird... I had two references missing.. Office Object Library 10.0 and ActiveX Data Objects 2.7.

So because the XP machine did not have these library files, it couldn't work out the Format function.. and the 2k machine could... obviously it has the libraries.

I've dropped them down to 9.0 and 2.6 .. both PC's have these libraries.



------------------------
Hit any User to continue