As a long-ago and long-time user of dBase, I am trying to update by learning Microsoft Access via an online course while actually doing the examples and such in OpenOffice Base (sounds complicated and I guess it is). In most areas I can work out...
As a long-ago and long-time user of dBase, I am trying to update by learning Microsoft Access via an online course while actually doing the examples and such in OpenOffice Base (sounds complicated and I guess it is). In most areas I can work out equivalent steps, but I have run aground on entering input masks in OpenOffice to match the Access masks. Take for example, masking phone numbers in the field properties of an input field so they will automatically be entered in the format (###) ###-#### by typing in the numbers only. I can do this easily enough in dBase and I can see how Access will do the same thing if you enter in the field properties for creating a record field, the mask "(999) 999-9999" which I guess is then actually rendered by Access as '\(999") "999\-999'. I have a similar problem in entering Boolean properties of the field -- either requiring specific text strings, or setting limits on numerical entries. The OpenOffice help documents do not cover this at all well. Is there an OpenOffice expert on hand that can point me to an answer.