format$ question

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

In a query top line i use 'csz:[city] & ", " & [state]
& " " & format$([zip],"@@@@@-@@@@")' It works fine on
regular network connections but doesn't work on terminal
server connection. If I take the Format$ command out
before the zip it works. I also tried it in the report in
a textbox controlsource and it gives #name?. Any ideas
would be useful.

Martin
 
Hi Martin,

It could be caused by missing reference,

-In the database on terminal server, Open the Visual basic editor -Click
Tools, References -check if there is any missing reference and remove it.
-Click OK, close the VB editor -Restart Access and check the query.

For more information on what references to set, please look at:
Q197110 - ACC2000: References to Set When Working with Microsoft Access
http://support.microsoft.com/support/kb/articles/q197/1/10.asp

Please feel free to reply to the threads if you have any concerns or
questions.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


--------------------
| Content-Class: urn:content-classes:message
| From: "martin" <[email protected]>
| Sender: "martin" <[email protected]>
|
| In a query top line i use 'csz:[city] & ", " & [state]
| & " " & format$([zip],"@@@@@-@@@@")' It works fine on
| regular network connections but doesn't work on terminal
| server connection. If I take the Format$ command out
| before the zip it works. I also tried it in the report in
| a textbox controlsource and it gives #name?. Any ideas
| would be useful.
|
| Martin
|
 
Back
Top