Hi -

It has been so long since I designed a particular database that I am not sure what I did.  

I have a "state" field and no matter how the text is entered, it appears in capital letters e.g. GA

I checked the programming and did not use any for that element, so I assume there is a field template.  I cannot, however, find one, nor do a get a clue when I go to property viewer for that element, nor can I find anything in the programming manual on the use of templates.

So, I would like to know how to find out where/what it is.

My "problem" is that althought the state appears in dapital letters in the database it prints (in a merge document - using exported data) the way the text was entered; e.g. GA, Ga; ga; etc.

So, my next question would be how can I get it to print the way the text appears in the database.

Thanks!

Erika -

Hi ,

I did check the format setting and I did look under the format setting and clicked on the other tab (I forgot that I DID find an "entry template" there; however there was no value for an entry template).  I also went to the Property view, clicked on template and pressed F5 (because I know that pulls the current "value" into the field) but there was nothing.

Also, when I first checked for programming, I only checked the State element because it seemed to me that (had I used programming) I would have put it in the "On Element Exit" event.  And, indeed, when I exit the element (no matter how I enter the text), when I exit the field, it is changed to upper case.  

Anyhow (still feeling "foolish"), I went back and checked each and every programmed element and I could not find any programming affecting that field.

So my 3 original questions are still pending but, to me, they are now even more baffling than before.  My only "defense" is that "I plead senility."  lol

- Spencer

Erika -

Just to be clear, I DID go to the Property Viewer but since I found nothing I just thought I would see if I could bring something up in the editor.

Also (while in the Property Viewer), I had also looked at the System setting (but never understand it).  I thought I would find the info in the entry template.

In any event, the Display Format shows:  Lorem ipsum dolor sit amet [SYSTEM]

I'm sure I will probably still need help till I get this through my head, but in the meantime, if you could tell me where I could find the "instructions" in the Sesame guides, it might just help shed some light, while I'm waiting for further assistance.

Thanks!

Erika -

I know that I did SOMETHING to cause that element to be all uppercase, because I always want the state abbreviation to appear (and print) that way.

I just exported the programming to an ascii text file and searched for toupper - and it was not found.  

it works on element exit so something is causing it.  It does not occur in any other elements.  

Even though I realize you are saying that the entry template would not do this, I would still like to know where I can find information on what it does do (for future info, if nothing else) and, of course, I still need to resolve my initial problem.

Thanks!

Sure; how and where should I send it?

(I'm sure it's not magic and that there is simply something I am overlooking).

Is there a way I could find the "date" the publications were produced.  I looked in both the user and programming guides and could not find anything on entry template (even in the index).  Is it possible I don't have the latest version?

Hammer wrote on Oct 14^th, 2009 at 12:02am:

Don't you mean "support@lantica.com"?  

Wow, a response only one minute after an edit.  Talk about fast!

AHA!  "Custom Format"  - so it wasn't magic after all.  That raises another question, however.  No matter how hard I tried I could not figure out any way to see this in the property VIEWER.  Shouldn't that be reflected - in the viewer - since it's crucial to the behavior of the element .... and how else could I tell that I had used that setting?

I know how to change it back but that takes me back to another question I asked.  If you use the custom format (don't know why I was hung up on Entry Template), is there a way to have it print as "viewed" i.e. ALL CAPS?

If not and I use programming instead (toupper) will THAT enable it to print as "viewed" i.e. ALL CAPS?

As for the Program/User Guides, I downloaded them from the web-site and do not see a version # or date issued anywhere.  

Thanks!