[AccessD] Droping trailing zero

Fixed and 2 decimals is a numeric format for *display*.  If you write
a numeric value, it isn't controlled by display properties.  If you
enter a number, it tries to write a number, hence the  dropped zero,
since the decimal point makes the zero unnecessary for numeric
handling.  If you don't enter a decimal, the entire number entered is
significant, so it writes it.

This gets more confusing with every reply. Are you sure the field is a
text field?  The behavior you're describing is distinctly numeric.  If
the field is bound, it should behave according to the datatype of the
field.

Charlotte Foust

On Thu, Aug 26, 2010 at 1:58 PM, Steve Turner <sturner at mseco.com> wrote:
> Hi Stuart,
>  The NewJobNo table is in Access mdb
> We link in all the SQL tables with ODBC. I will probably change the
> report query to an expression that I have to key in at time of
> generation. I can see on the properties tab for the text box that there
> is also no plain text selection. Strange though that if you set it to
> Fixed and 2 decimal places it won't write that to the file as text
> without drooping the last zero's. If I don't put the period in there it
> will write it.
>
> Oh just tried the   Job = txtNewJobNo.value  you suggested. didn't work
> either.
>
> Steve A. Turner
> Controller
> Mid-South Engineering Co. Inc
> E-Mail: sturner at mseco.com and saturner at mseco.com
>
>