Remove quotes from default value in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using unbound controls in a database application and whenever I move
programatically to a new record a need to pass the default value to the
controls. That all works fine except all controls that don't have a default
value now have the "" empty set value in them and quotes around controls that
did have a value in that property.
 
Hi,


It is more likely that the controls have NULL, which is not the same as
the empty string (a string with no character).

I don't understand your second part.

Why you are not using bound controls? Access Forms are designed for
that, and are efficient dealing with these scenario.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top