Get str constant to constant
Thanks Tony but it is still coming up with "Type Mismatch" error (runtime
13)
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
Download Jackaroo (an IT Help Desk application) at Web:
http://jackaroo.net.au
Quote:
> > I have a list box of 2 cols bound to a table of 2 fields fldGrphTypeName
and
> > fldGrphTypeConstant (both are text). The fldGrphTypeConstant contains a
> > vbConstant for a graph type and therefor when I use the expression:
> > Me.Graph1.Object.Application.Chart.ChartType = ctlGraphType.Column(1)
> > ctlGraphType.Column(1) comes through as a string and not as a constant.
> > How can I either convert it to a constant or derive the number value of
the
> > constant?
> try this
> Me!Graph1.Object.Application.Chart.ChartType =
CInt(ctlGraphType.Column(1))
Quote:
> --
> Tony Oakley (Microsoft Access MVP)
> GSXR1300R Hayabusa
> 300hr 240GB TiVo
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.480 / Virus Database: 276 - Release Date: 12/05/2003