Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Debug Window

Status
Not open for further replies.

JoeF

Technical User
Nov 30, 2000
54
0
0
US
I used to go into view Debug Window in the older version of Access, but I can't find this in the new version of Access. Does such a thing exist?

I want to test the following:
Public Function PRICE_RANGE(PRICE)
'TAKES A PRICE AND CATEGORIZES IT IN ONE OF THE FOLLOWING RANGES.
Dim PRICE
If PRICE <= 10 Then
PRICE_RANGE = &quot;$10.00 AND BELOW&quot;
ElseIf PRICE > 10 And PRICE <= 20 Then
PRICE_RANGE = &quot;$10.01 TO $20.00&quot;
ElseIf PRICE > 20 And PRICE <= 30 Then
PRICE_RANGE = &quot;$20.01 TO $30.00&quot;
ElseIf PRICE > 30 And PRICE <= 40 Then
PRICE_RANGE = &quot;$30.01 TO $40.00&quot;
ElseIf PRICE > 40 And PRICE <= 50 Then
PRICE_RANGE = &quot;$40.01 TO $50.00&quot;
Else
PRICE_RANGE = &quot;OVER $50.00&quot;
End Function


I used to be able to go into the debug window, type:
print price_range(15) <enter>
The debug window would give me an answer based off my code.
 
It is the Immediate window in Access 2000 and 2002.

Steve King Growth follows a healthy professional curiosity
 
By &quot;new version,&quot; I assume you mean Access 2000? If so, then the Debug window is now called the Immediate window, and you can still bring it up with Ctrl+G.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top