Hello my friends! I need some help with a chart report I am using in Access 2000. The SQL behind the chart uses the following string:
Z: "Next"+Space(1)+Format([subchrtCoopPercAvgVolPerAgent].[ProdAgents],"#,###"+Space(1)+"Agents /"+Space(1)+Format([subchrtCoopPercAvgVolPerAgent].[PercAgents],"#%"+Space(1)+"of Active Agents"
My challenge is to force a line-break after "Agents /" so the axis values are equally distributed and the line-breaks where I want instead of where ever it defaults.
The way the axis line looks now is:
Next 128 Agents / 1% of Active
Agents
The way I want it to look is:
Next 128 Agents /
1% of Active Agents
I have tried +chr(17); and all I get is a little box where the line-break is suposed to happen. Any suggestions?
Bryan Meek
bmeek@adelphia.net
Z: "Next"+Space(1)+Format([subchrtCoopPercAvgVolPerAgent].[ProdAgents],"#,###"+Space(1)+"Agents /"+Space(1)+Format([subchrtCoopPercAvgVolPerAgent].[PercAgents],"#%"+Space(1)+"of Active Agents"
My challenge is to force a line-break after "Agents /" so the axis values are equally distributed and the line-breaks where I want instead of where ever it defaults.
The way the axis line looks now is:
Next 128 Agents / 1% of Active
Agents
The way I want it to look is:
Next 128 Agents /
1% of Active Agents
I have tried +chr(17); and all I get is a little box where the line-break is suposed to happen. Any suggestions?
Bryan Meek
bmeek@adelphia.net