Data in a databound control is not being added to an access database record

[jazFunk]

In an Access database, I have fields (datatype = dbl) named "length", "height", and "sqrfeet". In my vb code I'm doing calculations to figure the square footage by multiplying the length * height divided by 144. The formula works just fine, but when adding the record to the database the length and height are added, however the square footage calculation is not getting added.

I assign the result of the calculation to the text box which is databound to the sqr. feet field in the database.

Any ideas where the bug might be? I'm using Visual Basic 2008.

 

[Aaron Bex]

The most likely cause of the issue is that the text box is not configured to update the underlying database field when the data is changed. To ensure that changes are saved to the database, set the text box's 'DataBindings.UpdateMode' property to 'OnValidation'. This will cause the field to be updated whenever the text box loses focus.

 

[quicknote]

Based on the information provided, it appears that the issue may be with the data type of the "sqrfeet" field in the database. Since it is set to "dbl" (double), it is possible that the calculation result, which may be a decimal or floating point number, is not being accepted by the database.

One solution could be to change the data type of the "sqrfeet" field to a more precise data type, such as "decimal" or "float". Another solution could be to round the calculation result to a whole number before assigning it to the text box and adding it to the database.

It is also important to check for any error messages or prompts that may be occurring during the data insertion process. Additionally, double-checking the code for any typos or syntax errors may also help identify the issue.

Overall, it is important to ensure that the data types of the fields in the database are compatible with the data being added, and to thoroughly test and troubleshoot the code to identify any potential issues.