Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

I have a database Form which includes two controls -

     Job Code             varchar(3)    Pattern Field (Job Code is an
abbreviation of Job Code Name)

     Job Code Name   varchar(25) List Box

The idea is that the user can enter the Job Code and the List Box will
display the Name.   Alternatively, the user can drop down the List Box,
choose a Name and the Job Code will be displayed

I wanted to force upper case in Job Code, so I entered ‘AAA’ in the Pattern
Field Edit Mask. This works fine for 3 character Job Codes, but some of
them are just two characters. For these, Job Code is displayed as upper
case, but a space is appended to make up the 3 characters. This means that
the Job Code is not recognised by the List Box, and as well, I get a
referential integrity error when I try to save the record, the reason being
that for example, Job Code ‘SP ’ is not the same as ‘SP’.

So my question is, can I change the Edit Mask in some way to get around
this problem?

As far as I can see, this doesn’t seem to be possible. My only solution is
to change the 2 char Job Codes to 3 chars. I have only 7 with 2 chars in
the lookup table, but there are a lot of these in the Jobs table.
Relatively easy to do with an update query, but I didn’t want to do that,
if there was an simpler solution.


Marion & Noel Lodge

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.