Format 4 UOM

[actionashley]

Does anybody know of a way to format an unbound control on a report to always show a unit of measure. So whatever number is put in shows the ' foot symbol or " inch symbol. If I put it in as a label it doesn't stay aligned if the number changes digit size.

 

[SOS]

Why use an unbound control? You can change the control source of your bound control to the value. So, if you have a UOM field which defines the UOM and then the value you can change your value control source to something like this:

=[ValueFieldNameHere] & [UOMFieldNameHere]

remember to use square brackets as shown.

 

[actionashley]

Genius !!!!!!!!!!!!!!!!!!!

Thanks Much