textbox to show description of focused field.

[shani908]

Hello

Please advise how to set a textbox to description of a field? and update it as the focus move from one field to another ?

Thanks

[June7]

Possibly code in each control's GotFocus event that sets value of Description textbox.

[CJ_London]

Are you talking about the field description in the table design?

if so the code in the got focus event would be something like

Txtdesc=tabledefs(“mytable”).fields(thiscontrol.co ntrolsource).description

you haven’t provided any names so substitute with your names

[shani908]

Thank you for replying . I tried but I am a beginner with Access and was unable to get it running.
Properties of table is attached.
Properties of form is attached.

I used BuildEvent to make some changes but its giving error. Please advise.

Thanks

Are you talking about the field description in the table design?

if so the code in the got focus event would be something like

Txtdesc=tabledefs(“mytable”).fields(thiscontrol.co ntrolsource).description

you haven’t provided any names so substitute with your names

[CJ_London]

I missed currentdb - and you don't have the rest quite right

text39=currentdb.tabledefs(“mytable”).fields(thiscontrol.controlsource).description

the code needs to go into each of the other controls got focus event, not text39

thiscontrol is the name of the control that the code is in

for future reference, when posting code, please copy/paste it and use the code tags to preserve formatting (highlight the pasted code and click the # button)

and for your table/field design it is a bad idea to have spaces and non alpha numeric characters in their names (e.g. Last Name, Zip/Postcode). Leaving them in can cause some weird errors - even if you surround with square brackets. Can virtually guarantee if you don't fix this, every time you post a question you will be told again.

Also recommend you get into the habit of giving controls meaningful names. Typically a textbox wouldhave a txt prefix, combo, cbo, list lst etc. eg txtFldDesc instrext of Text39

[shani908]

Thanks noted ..

I am still getting error, please advise .

attached error2.png and vbacode.png

I missed currentdb - and you don't have the rest quite right

text39=currentdb.tabledefs(“mytable”).fields(thiscontrol.controlsource).description

the code needs to go into each of the other controls got focus event, not text39

thiscontrol is the name of the control that the code is in

for future reference, when posting code, please copy/paste it and use the code tags to preserve formatting (highlight the pasted code and click the # button)

and for your table/field design it is a bad idea to have spaces and non alpha numeric characters in their names (e.g. Last Name, Zip/Postcode). Leaving them in can cause some weird errors - even if you surround with square brackets. Can virtually guarantee if you don't fix this, every time you post a question you will be told again.

Also recommend you get into the habit of giving controls meaningful names. Typically a textbox wouldhave a txt prefix, combo, cbo, list lst etc. eg txtFldDesc instrext of Text39

[Micron]

Your table name is not "myTable" perhaps??
EDIT - nor is your control name "thiscontrol"?

[June7]

As CJ already instructed, change the generic "mytable" and "thiscontrol" to your actual object names.

You will often see generic aliases in sample code because we don't know your object names.

[shani908]

As CJ already instructed, change the generic "mytable" and "thiscontrol" to your actual object names.

You will often see generic aliases is sample code because we don't know your object names.

Thanks . Noted . It worked