In short I am unable, in Access 2000, to pass more than one parameter to a 

Function. I keep getting syntax error or expected =.



If I use the debug window and type say ?capitalize

(?tblcompany?, ?country?) the function runs correctly.



However if I create a command button and in the On Click put the same 

statement in (minus the ?) I get syntax error. In this instance both 

parameters are String variables as required by the Function Capitalize. I 

have tried other test Functions with other variable types and the same 

problem arises. My only success is when I have a function that requires 

only one parameter.



I have DAO 3.6 installed and need to call a function, amongst other 

things, from the On Click event of a command button.



Can anyone help please ?



Regards



Mike Poulton