I want to resue a control on a form, and change the data in it from a fixed number with 2 decimals to text and back depending on which datasource I am pulling.
The issue I am having is that when I put in straight text - there is a # in the text and in truncates the rest of the string after the #.

I tried to make a custom format me.txt00.Format = "@ " and I am still getting truncated data.

How do I tell the control that it is not a number format or a date format so it stops truncating the text after the #.

I simply made a new control and didn't format it as a number and the data shows up fine.
So how can I go back and forth using the same control?

Will it break on me later if I just use my new control?

Any thoughts or directions would be greatly appreciated.