How to show two diff. decimal places on a textbox

[Bobby1st]

Hello,
I have two table columns, one Col A have zero decimal places (integer) and Col B have 3 (0.020).

On the Form, the textbox's data source = iif([Col A]= 0, [Col B], [Col A]) However, if I select decimal format 3, the interger will result to 2.000 while if it's the other it will cut it off.

I tried different ways to approach this but didn't work, can you help?

I appreciate it.

Thank you.

 

[shades]

Howdy. Are you doing this in Excel? IIF is not in Excel.
________
Honda VT250 specifications

 

[Bobby1st]

My apology, should have been in Access.