Look Up Tables

[Guest]

I have two columns that draw from Look-up tables. The look up table has the
information in "ALL CAPS" but the information in one field has the first
letter of each word a capital and the other field puts everything in lower
case. I have been looking at the formatting and I can't seem to find out why
it is doing this.

Thanks in advance for your help!!!

 

[George Hepworth]

Where are these "columns" and how are they being used?

George

 

[Guest]

I have two tables. One Organizations - One Subspecialties. I have created
an order form that has a look up for Organizations. When the drop down box
opens I see the Organizations - all in caps. When I choose one, it goes on
the form with only the 1st letter of each word capitalized. Not all bad but
I do not see why this is happening. Nothing I did intentionally. Need to
know why this happens.

The second look up field in supspecialites - on the same form. I once again
see my choices - all in CAPS. WHen I choose from this I see the choice in
lower case. Once again - I do not know why.

Thanks!!!!

 

[John W. Vinson]

I have two tables. One Organizations - One Subspecialties. I have created
an order form that has a look up for Organizations. When the drop down box
opens I see the Organizations - all in caps. When I choose one, it goes on
the form with only the 1st letter of each word capitalized. Not all bad but
I do not see why this is happening. Nothing I did intentionally. Need to
know why this happens.

The second look up field in supspecialites - on the same form. I once again
see my choices - all in CAPS. WHen I choose from this I see the choice in
lower case. Once again - I do not know why.

Thanks!!!!

Take a look at the Format property of the field in the table, and the format
property of the controls in which the value is displayed. If there is a format
of

just a rightpointing caret, the field will display in all caps regardless of
the case in which it is stored.

John W. Vinson [MVP]

 

[Guest]

I have looked at every format field that I can find and > is there.
Something somewhere is overriding the format. I have put the entries into
the tables in all "CAPS" but somehow I have an override and I don't know
where to look.

Thanks again!!

 

[John W. Vinson]

I have looked at every format field that I can find and > is there.

If > is there, then THAT IS WHAT'S DOING IT.

The data is being stored in mixed case. It's being displayed (thanks to this
format) in all caps.

Something somewhere is overriding the format. I have put the entries into
the tables in all "CAPS" but somehow I have an override and I don't know
where to look.

No. You have *NOT* put the entries into the table in all caps! It looks like
you have, because of the format; but the format does not control what's stored
in the table, only how it's displayed. If you display the value in a different
context (a combo box say) then it will display what is actually there in the
table - mixed case.

John W. Vinson [MVP]