Re: listview problem....


"Jan Hyde" <StellaDrinker@xxxxxxxxxxxxxxxxxxx> wrote in message
news:7udd729b9q1j75eh6j1mhmdrd2tpopame7@xxxxxxxxxx
"Dave" <nobody@xxxxxxxxxxx>'s wild thoughts were released on
Thu, 25 May 2006 16:04:27 +0100 bearing the following fruit:

Leading digits would be a problem because the listview, treeview and
related
controls don't allow keys that start with a number (to prevent confusion
with indexes as either can be used).

People often want to store a number as a key. The *best* way
to achieve this is append a character to the *end* of the
number...

In other words, your quite wrong about that, but don't take
my word for it, try it yourself.

Mea culpa

Strange, I often use a database record ID as the key with a letter or two to
stop the key from being a number. For some reason I must have thought that
the type coercion seen in Val() and CLng() applied here where it converts
until it runs out of digits.
That it doesn't will make life a bit easier - thanks for pointing me into
the right direction.

Dave O.


.

Relevant Pages

  • Re: listview problem....
    ... controls don't allow keys that start with a number (to prevent confusion ... People often want to store a number as a key. ... to achieve this is append a character to the *end* of the ...
    (microsoft.public.vb.general.discussion)
  • Re: Tuesday Morning ...
    ... To ward off any confusion, ... Tuesday Morning is a store. ... Whoo hoo! ... Just another reason to vote *before* I go to work - get by ...
    (rec.food.cooking)
  • Re: date format problems
    ... I suspect that you are being confused by language ... I don't see a field in your query with the ... Sorry if this interjection just adds to the confusion. ... >I put the controls on the form and using the expression builder - ...
    (microsoft.public.access.formscoding)
  • RE: Help assigning Now to a bound or unbound control
    ... The group of option buttons have the names optIN etc and they are all bound ... I think there's still some confusion here between controls and properties ... the custom properties defined for the form in the tab under ...
    (microsoft.public.outlook.program_forms)
  • Re: value of a control based on values in multiple other controls
    ... I would like to store the value as it will be used to link the information ... reference the other controls in the way I want (adding, ... [HSA] ... This is the third part a one digit number based on the name of the ...
    (microsoft.public.access.macros)