Text field with numbers and or letters
I have a text field called P.O.# The reason it's a text field is that some P.O.'s we receive have a text prefix i.e. PR92828. Some are only numbers i.e. 63636. If I enter 63636 as the P.O. number a...
Forum Discussion
Just as a follow up....
I created a ticket with QB support. Explained in detail. I know it wasn't my imagination because I found other with the same experience. One that gave me the.....change to numeric then back to text....which worked.
QB support said it should not be adding commas in a text field.
So, I added a new TEST text field this morning to the same table where the situation occurred.
Lo and behold it behaved correctly. I'm writing it off to an anomaly. But as a programmer and developer for 35 years my instinct was to track down what was causing it. Glad it was resolved.
Thank you for your help.
I created a ticket with QB support. Explained in detail. I know it wasn't my imagination because I found other with the same experience. One that gave me the.....change to numeric then back to text....which worked.
QB support said it should not be adding commas in a text field.
So, I added a new TEST text field this morning to the same table where the situation occurred.
Lo and behold it behaved correctly. I'm writing it off to an anomaly. But as a programmer and developer for 35 years my instinct was to track down what was causing it. Glad it was resolved.
Thank you for your help.