[AccessD] Droping trailing zero

What happes if you use

 Job = txtNewJobNo.value

rather than 

 Job = txtNewJobNo


On 26 Aug 2010 at 15:38, Steve Turner wrote:

> Thanks Lambert,
> My younger boss who is a little sharper in Access than I had this
> problem some time ago when we were trying to printout labor recaps
> just for one job that ended in zero.  Some of the properties of the
> text box will even truncate it. You would think that if it displays
> correctly then it would write that to the table ok. You can go into
> the table directly and type it in and its ok. I was hopeful that there
> might be some short code to make sure it was text and formatted
> correctly before I updated the table. That table is just a one field
> one line entry to hold the job number. I know I can change the report
> query to ask for the number but I was hoping to solve this other
> problem also.
> 
> Steve A. Turner
> Controller
> Mid-South Engineering Co. Inc
> E-Mail: sturner at mseco.com and saturner at mseco.com
>