list boxes

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I created a list box with a number field. It is
displaying this number with 2 decimal positions even
though this number is defined in the table with 0 decimal
positions. How do I get rid of the decimal positions in
my list box?

Also, How do I get the list box to only display data that
matches what was entered in the previous field

Explanation:
- [Apartment number] is entered for "Moveout" table in
previous field.
- The next field is the list box which contains
[Lastname] and [Apartment number] for selection from
the "Tenants" table to update the [Lastname] field in
the "Moveout" table.

How do I get the list box to only display records
whose "Tenants" [Apartment number] equals the [Apartment
number] that was entered in the previous field?

Any help will be greatly appreciated. Thank you.
 
Jean,
Not sure why you're getting 2 decimal places. In your table the field
should be Byte, Integer, or Long... not Single.
If that doesn't do it... try Formatting the ApartmentNumber in the query
behind the list box... with a column like...
NoDecApartmentNumber : Val(Format(ApartmentNumber,"#"))
 
Back
Top