CODEWITHSUNDEEP
vbams-access
user3791372
user3791372

Reputation: 4695

Setting field of Access table using VBA from form

I'm trying to set a value of a field from a subroutine which I'm calling from an event handler. I'm simply doing width = 5

However, the field value isn't changed. However I can do height = 5 and the field value is set as expected. The field value for width remains unchanged at 12186.

I've tried changing the field name to image_width to no avail.

The form has neither controls height nor width.

What am I doing wrong / why is this one field not changing. I've tried deleting the field and recreating, and I don't see anything on this field that limits the setting of data.

Upvotes: 0

Views: 91

Answers (1)

Andre
Andre

Reputation: 27644

Every form has an inbuilt property .Width so you can't use that for a field name.

A form doesn't have .Height, since this is a property of the form sections.

image_width shold work, though. Are you sure you edited all relevant settings?
i.e. Table field name, form field Name, form field Controlsource, VBA code?

Upvotes: 1

Related Questions