I'm having various degrees of success using @Insert to populate a variable with items to fill my combo boxes with PopulateListElement.  It's working well, but I have a few minor questions.

When the final value in the list is selected, the element fills with that value plus the characters ^J.  I find that I can avoid this by ending the list of values with a semicolon, however this then allows the user to select a "blank" at the bottom of the list which fills the element with ^J.  I suppose I can suppress this item/fill with programming, but is there a better way that I'm not aware of?

Secondly, I kinda/sorta remember back in Eriks's designing class that there was a way to have "none" appear as a selection item, which would return no value.  But I've forgotten how this is done.  Is it all hard coded or is "none" some kind of built-in selection somehow?

Anyhoo, for what it's worth, here's my current code:

// Populates the Labor Category combo box with the contents of LaborCategories.txt

Var vCats as String

vCats = @Insert("LaborCategories.txt")
PopulateListElement(LABOR_CATEGORY_1, vCats) 

And the contents of "LaborCategories.txt" is

Lead Rigger;Rigger;1 Man Crane Crew;Driver only;Forklift Operator;Laborer;2 Man Crane Crew;Electrician;Foreman;Foreman/Supervisor;Millwright;Supervisor; 

Thanks in advance.

Infinity wrote on Aug 11^th, 2006 at 6:12pm:


If you look in the coursebook for the Programming class, you will find the code to which you refer all nicely typed out for you so you don't have to remember it.

Is the hard-coding of "None" case sensitive?

Quote:

But...that's what they'd be expecting me to do!

Quote:

Ah, yes, there it is, page 18.  Thanks.  The asterisk...is that so alphabetizing is ignored?

Quote:


Alphabetizing is not turned off, but the *  is used to force that option to always appear at the top.

Quote:


On Form Entry is really On Record Entry so if you add a new entry to the txt file and then advance to another record your combo box should have that new value in it.

-Ray