[Solved] Cell character limit in form not reflect SQL limit

Discuss the database features
Post Reply
Ron19855
Posts: 10
Joined: Thu Dec 27, 2018 11:25 pm

[Solved] Cell character limit in form not reflect SQL limit

Post by Ron19855 »

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.
Last edited by robleyd on Wed Jun 03, 2020 1:25 am, edited 2 times in total.
Reason: Tagged [Solved]
OpenOffice 4.1.6 - Windows 7 Ultimate
UnklDonald418
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

Post by UnklDonald418 »

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.
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
Ron19855
Posts: 10
Joined: Thu Dec 27, 2018 11:25 pm

Re: Cell character limit in form does not reflect SQL limit

Post by Ron19855 »

That's what I was looking for, thank you!
OpenOffice 4.1.6 - Windows 7 Ultimate
Post Reply