text box field #Name?

[Guest]

I have a field on a form that has the control source set to
'=MyFunc$(xxx,yyy)' We have had this database/program for several years and
have never had any problems. However, I (one of the programmers) just
recently received a new computer and for whatever reason i'm getting an error
on that field. When i look at the control source now it shows
'=[MyFunc$](xxx,yyy)' It would be easy to change this one field
'=MyFunc(xxx,yyy)' which will work, however, I'm sure that this same issues
is in several forms. There are more than 100 computer using the database
without any problems. I running Win2k, Office 2000 and both with the most
recent updates.

So my actual question is, Where is this problem coming from and how can I
get rid of it?

Thank you for your thoughts.

 

[Guest]

Are you sure that the same version of Access is on all the computers? That
includes fixes and service packs. Are you sure that all the Access setup
options are exactly the same on all the computers? '$' is an invalid
character for an Access function name; that's why the square brackets were
generated.

 

[Guest]

I have checked a number of things, versions, option setting (both in access
and in code) and we are still not having any luck. All computers have the
latest service pack installed. I'm sure a library was installed for some
other application and it has priority over the normal access libs.

You're right, something is invalid with this setup but the code has been
working fine on all the other developers computer and users computers. a $
is actually allowed but it is only allowed as the final character of the
function name. The $ forces all return values to be a string.

Function MyStr$(xxx)

is the same as

Public Function MyStr(xxx) as string

It is a carry over from the old way of programming.

Are you sure that the same version of Access is on all the computers? That
includes fixes and service packs. Are you sure that all the Access setup
options are exactly the same on all the computers? '$' is an invalid
character for an Access function name; that's why the square brackets were
generated.

I have a field on a form that has the control source set to
'=MyFunc$(xxx,yyy)' We have had this database/program for several years and
have never had any problems. However, I (one of the programmers) just
recently received a new computer and for whatever reason i'm getting an error
on that field. When i look at the control source now it shows
'=[MyFunc$](xxx,yyy)' It would be easy to change this one field
'=MyFunc(xxx,yyy)' which will work, however, I'm sure that this same issues
is in several forms. There are more than 100 computer using the database
without any problems. I running Win2k, Office 2000 and both with the most
recent updates.

So my actual question is, Where is this problem coming from and how can I
get rid of it?

Thank you for your thoughts.