September 17th, 2013, 11:58 AM
MS Access Change textbox format from Fixed number to straight text
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.
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.