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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access subreport link by code 1

Status
Not open for further replies.

earme

Programmer
Jul 27, 2000
155
US
Hello,

I have an on demand subreport that you get to via a link. The link shows up as the order number and you click on it to view the order items. However, the order number is showing up in #,###.00 form and I don't want decimal values or the comma. I thought perhaps I could format this in my code (I'm developing an ASP app, so I'm using VBScript), but cannot find a way to reference the link.
Could someone please help!

Thanks,
Earme
 
Right click on the subreport object in design. Select "Format Subreport" and click on the tab marked "Subreport".

Click on the "Caption" formula button and you should see the name of the field displayed as the link. Change the formula to say:

Totext ({table.numberfield},0,"") Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top