Re: List Vs Combo and Null values

On May 28, 11:40 pm, "Brent Spaulding \(datAdrenaline\)"
<datadrenal...@xxxxxxxxxxxxx> wrote:
Is the control BOUND to a Field of TEXT datatype? ... if so, your field
should be defined to allow Zero Length Strings and possibly set the default
value to "" (a zero length string) simply because a ListBox and ComboBox
will only return a Null if NO ITEM is selected, if an item is selected the
control will return a String ...even if the bound column is numeric, it is
still a string.

--
Brent Spaulding | datAdrenaline | Access MVP

"Debbiedo" <deb_dolit...@xxxxxxxxx> wrote in message

news:68bfb844-cfc0-4f5c-b907-b7d1160a88df@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Why when I have this syntax in the Row Source for a List Box, the null
values display the word "CAN" but when I convert it to a Combo Box (to
eliminate the annoying black background) the word "CAN" does not
appear? What would be the work around for this? I want to stay away
from macros because this report is shared and macros locked out by
many of its users.

"";"CAN";"X";"CANNOT"

Thanks

Deb- Hide quoted text -

- Show quoted text -

The properties are set to Allow Zero Length and default is set to "",
but the results are still displayed only if the value in the field
equals "X". The word "Can" does not display when the value in the
field is Null or "".

Any other ideas? Can I do this using vb, if so, how? I may have to
just pass the word not to disable macros.

Thanks

Deb
.

Relevant Pages

  • REPRESENT revisited
    ... Forth-94 has few floating point display functions [none in the ... If u is greater than zero the character string shall consist ... If u is zero the string shall consist of one digit representing ...
    (comp.lang.forth)
  • Re: Reproducing java calculations in UNIX
    ... quotient goes in x, also a double. ... is greater than zero) only the fractional part of the ... {fraction is 52 zero bits, ... is converted from string to floating point (string ...
    (comp.unix.shell)
  • Re: REPRESENT revisited
    ... >has given rise to implementations that differ in critical ... The required compatibility is 1), but 2) makes it much easier to get ... > If u is zero the string shall consist of one digit representing ... But I think it is a very bad idea if a word that should fill a string ...
    (comp.lang.forth)
  • Re: Allow Zero Length String Property - 2000 vs 2003
    ... Are you the same person who posted the 'Allow Zero Length String in MS ... "Ash" wrote in message ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Macro Question
    ... The string you want Microsoft Excel to search for. ... SearchOrder Optional Variant. ... The settings for LookAt, SearchOrder, MatchCase, and MatchByte are saved ... > include a search for occurrences of zero. ...
    (microsoft.public.excel.programming)
Quantcast