Re: break down of a code

Tech-Archive recommends: Speed Up your PC by fixing your registry

"GiBB" <GiBB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BF040165-9745-42B7-AA34-55526C27B7C9@xxxxxxxxxxxxxxxx
Thanks Keith for this, i have put this into VB as you said, the only problem
is now, im getting the runtime error "object doesn't support this property or
method"

would this be because i am trying to link a combo box into a memo field? if
so is it true that you can extend a text field box to more then 255
characters via VB?


You want your text box to contain whatever is chosen in the combo box? Not sure why you'd want that but this in the form's *before* update event should do the trick:

Me.txtMyTextBox = Me.cboMyComboBox.Column(n)

using your own object names of course. Note the use of "." instead of "!" (more info http://doc.advisor.com/doc/05352).

It doesn't matter if the text box is bound to a memo field.

Keith.

.

Relevant Pages

  • RE: AccessDataSource constraining results?
    ... data from an access mdb file, the returned Memo field text value is ... bind the Memo field to a repeater and it seems work correct(the returned ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Exporting query to XL is truncating field data
    ... Transfertext or export to rtf may be truncate the field. ... When You Export an Access Report the Memo Field Is Truncated ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.access.queries)
  • RE: Exporting query to XL is truncating field data
    ... This is an adp project. ... Formatted Memo Field Appears to Truncate Data After 255 ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.access.queries)
  • memo field update transaction
    ... I need update or insert data in to memo field. ... but does support transaction rollback or commit ...
    (microsoft.public.access.formscoding)
  • Overflow error
    ... I have a memo field in the database that is linked to a textbox in a form. ... At the moment the problem field has 32,649 characters in it, and has the ... Private Sub titleholder_notes_GotFocus ... Which gives an error: Runtime error: 6, ...
    (microsoft.public.access.forms)