Apache OpenOffice Community Forum

I'm creating a data entry form and want to limit users to only be able to enter numbers into a certain field (barcode).

I don't need a message to come up telling the user that they're only allowed to enter numbers, I just want nothing to happen when they press anything other than a number key.

As a bonus, is there a way to stop input, as with the first question, after the user has typed in 5 digits?

viewtopic.php?f=13&t=88873&p=418327&hil ... ld#p418314

Look up "edit mask" and "literal mask" in the F1-help.

i would;

edit/form navigator/ 'choose your field' -- replace with formatted field
properties of formatted field ... VALUE MAX == 99999 .. so it rejects 100000 or more and
formatting [...] -- change to Number , remove decimal places -- it will reject letters when next field is click onto

its basic, so i would prob attach a note to the field for the user