General information
Category:
Forms & Form designer
Title:
Why does Combo.value change from integer to numeric?
I thought I had combos well in hand, but...
I have a combo, AgencyChoice on a form, w/the following properties set:
BoundColumn = 2
BoundTo = .T.
ColumnCount = 1
ControlSource = (none)
RowSource = SELECT description, code from agencydefs into cursor cTempAgencyDefs order by description
RowSourceType = 3 - SQL Statement
Style = Dropdown List
Value = 0
Agencydefs.Code is an integer field
With these settings, AgencyChoice.Value is an integer.
If I change ControlSource to IncomingCases.AgencyCode (AN INTEGER FIELD), AgencyChoice.Value becomes a numeric value with 2 decimal places.
Can anyone tell me why? or help me make it be an integer?
This has been driving me nuts for a long time now...I've tried to set THis.Value =INT( This.Value ) in various places to get it to be an integer, but cannot get it to stay an integer (I need this, to compare it w/an integer constant).
Please help! TIA, J
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only