Hello,
I have a from in Base with a varchar field. The field length is set to 128 within MySQL, however, the form caps out at 30. When in table view, the character view is accurately reflected is this problem doesn't exist; It is only within the form that I am experiencing this issue. Additionally, none of the other fields in the form have this issue and share the same field length as what they are set to in SQL. Is there a separate option for setting field lengths specifically for a form, or am I missing something here?
Thank you, any assistance would be greatly appreciated.
[Solved] Cell character limit in form not reflect SQL limit
[Solved] Cell character limit in form not reflect SQL limit
Last edited by robleyd on Wed Jun 03, 2020 1:25 am, edited 2 times in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
OpenOffice 4.1.6 - Windows 7 Ultimate
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Cell character limit in form does not reflect SQL limit
On the General tab of the Properties: Text Box dialog is a property
Max. text length
each text box on a form can have it's own value
A value of 0 should display all the characters.
Max. text length
each text box on a form can have it's own value
A value of 0 should display all the characters.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Cell character limit in form does not reflect SQL limit
That's what I was looking for, thank you!
OpenOffice 4.1.6 - Windows 7 Ultimate