2-Quick Questions

[djclntn]

I have 2-questions regarding Forms:



1) In many of my Forms I used a common field called, ‘hrs’ the DataType is, number, standard, decimal set at “1” e.g. (.5 1.0 1.5 2.0 2.5 etc) So I created a Table called “DurationsHrs”, set the number field properties as described & entered in the numbers. So far so good; when I create a Combo Box based on my “DurationHrs” Table, the numbers in the Combo Box comes up as: 0.50, 1.00, 1.50, 2.00, etc. I went into the Combo Box Properties, for the Format I have “Standard” & Decimal Places I have “1” Yet, when I run the Form the numbers in the “hrs” are still 1.00, 1.50 2.00, 2.50 – why?

2) With Conditional Formatting, can you somehow carry a set of rules created from one Form to another Form (or for that matter from 1-Report to another Report)? How?

[June7]

1. You mean the two decimals show in the RowSource? I just replicated that. Must have something to do with the values in combobox columns are actually strings, regardless of datatype in table. The combobox insists on filling in or truncating to two decimals. Note that if you set the combobox to 3 decimals the RowSource still shows 2. Only way to control that is to use Format function.
Select Format(Hrs,"0.0") FROM DurationHrs;

2. Only by copy/paste the object or controls.