<div>
Hi,<br />
<br />
In the query (RowSourceType property of your bounded graph), use a trick.<br />
<br />
Add the ascii code 255 to the selected field like this :<br />
SELECT &quot; &quot; &amp;&nbsp;X-AXIS-FIELD [...etc...] &nbsp;FROM ...<br />
Note : it appears here as a space but type ALT 255. If you use the space, it won't work.<br />
<br />
If this solution is acceptable, let me know.<br />
<br />
DS<br />

</div>


Hi,

In the query (RowSourceType property of your bounded graph), use a trick.

Add the ascii code 255 to the selected field like this :
SELECT " " & X-AXIS-FIELD [...etc...]  FROM ...
Note : it appears here as a space but type ALT 255. If you use the space, it won't work.

If this solution is acceptable, let me know.

DS


<div>
DS,<br />
<br />
This technique did the trick. &nbsp;Answer is accepted. &nbsp;Thanks.<br />
<br />
Dave<br />

</div>


DS,

This technique did the trick.  Answer is accepted.  Thanks.

Dave


<div>
<div class="content wysiwyg-content">
Using Access 97, the x-axis series is a text datatype with 14 numbers (i.e. 34554334554334). &nbsp;When I chart the data, the x-axis series labels are formatted in scientific notation (i.e. 3.4543E+13). I've verified that the database field and chart label object are formatted as text, but it seems to override to the unwanted scientific notation. &nbsp;Please help. &nbsp; &nbsp;Dave.
</div>
</div>


Using Access 97, the x-axis series is a text datatype with 14 numbers (i.e. 34554334554334).  When I chart the data, the x-axis series labels are formatted in scientific notation (i.e. 3.4543E+13). I've verified that the database field and chart label object are formatted as text, but it seems to override to the unwanted scientific notation.  Please help.    Dave.

Chart shows incorrect x-axis format

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.