>Hi all!
>
>One field of my table stores 1,2,3...etc.
>
>To make it simpler for my coding, I made them char and stored as 0001, 0002...
>
>But when I display them in a Grid, I dont want the zeros to be shown..
>
>Where in the grid should I configure, to make is display "1" when the value is actually "0001"? or should I not save them in this way?
>
>Thanks,
>Jimi
In what way does char make your coding easier?
Anyway, you can set the ControlSource to int(val(MyCharExpression)).
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)