ACC2000: Cannot Use New Visual Basic for Application Functions as Expressions

ID: Q225956

The information in this article applies to:

Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS

When you use one of the new Visual Basic for Applications functions as an expression, you may receive the #Name? error value. For example, if you set the ControlSource property of a text box to the expression =WeekdayName(6), the text box returns #Name? instead of the value Friday.

CAUSE

The FormatCurrency(), FormatDateTime(), FormatNumber(), FormatPercent(), InStrRev(), MonthName(), StrReverse(), and WeekdayName() functions are not supported as expressions.

RESOLUTION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Solution Provider or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Solution Providers, please see the following page on the World Wide Web:

http://www.microsoft.com/mcsp/

For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

Create a custom function in a module that uses the built-in Visual Basic for Applications function. Then call this function where you need the expression. For example, create the following function:


Function MyStrRev(strRev)
   MyStrRev = StrReverse(strRev)
End Function

After you have created the function, set the ControlSource property of the text box to =MyStrRev("abcd").

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.

In the Database window, click Forms under Objects, and then click New.

In the New Form dialog box, click Design View, and then click OK.

Add a text box to the form, and set the ControlSource property of the text box as follows:

=WeekdayName(6)

On the View menu, click Form View.

Note that the text box returns the #Name? error value.

Additional query words: pra vba

Keywords : kberrmsg kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug