Distinction between using .text and .value in VBA Access

by
  • “.text” gives you what is displayed
    on the screen
  • “.value” gives you the underlying
    value

Both usually give the same result, except when the corresponding control is

  1. a combobox or listbox control
  2. the displayed value differs from the bound column

Example:

  • id_Person is a combobox control in a form
  • the rowsource is “SELECT id_Person, personName FROM Tbl_Person”
  • column widths are “0cm;3cm”
  • bound column is 1

In this situation:

  • id_Person.text displays Tbl_Person.personName
  • id_Person.value displays Tbl_Person.id_Person.

.text property is available only when the corresponding control has the focus.

.text is a string value, therefore it cannot be Null, while .value can be Null

EDIT: .text can only be called when the control has the focus, while .value can be called any time …

More Related Contents:

  1. ms access vba code for update records through form
  2. How to add default signature in Outlook
  3. Combine rows / concatenate rows
  4. Is it possible to pass parameters programmatically in a Microsoft Access update query?
  5. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  6. Too few parameters Expected 1, recordset issue
  7. Show “Open File” Dialog
  8. How do I display a messagebox with unicode characters in VBA?
  9. Determining whether an object is a member of a collection in VBA
  10. MS Access VBA Error: Run time error ’70’ Permission Denied
  11. Automatically generating handling of issues
  12. Is it better to use ADO or DAO in Access 2007?
  13. VBA – Folder Picker – set where to start [duplicate]
  14. MS Access: how to compact current database in VBA
  15. How to loop through all controls in a form, including controls in a subform – Access 2007
  16. FileDialog doesn’t work
  17. Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)
  18. Determine real cause of ODBC failure (error 3146) with ms-access?
  19. Is there an equivalent to Thread.Sleep() in VBA
  20. Exporting MS Access Forms and Class / Modules Recursively to text files?
  21. How to get logged-in user’s name in Access vba? [duplicate]
  22. Pass a parameter into an access report programmatically
  23. finding latest file in a folder and opening it (vba access)
  24. Insert multiple records with a date range in MS Access
  25. MS Access VBA: Sending an email through Outlook [closed]
  26. SendKeys is messing with my NumLock key via VBA code in Access form
  27. Runtime error 287. Sending Emails through Outlook using VBA in Access
  28. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  29. Object variable or With block variable not set (Error 91)
  30. lastrow and excel table.

Leave a Comment