Automatically show remark comment in textbox (1 Viewer)

luzz · Apr 2, 2018

Hello everyone,

How can i show this on the textbox on my form? so that user will not need to keep typing or copy to the textbox and make the adjustment?

1) Please State:
2) Shrinkage: Maximum W: L : Twist:
3) PP sample -

NauticalGent · Apr 2, 2018

Sorry Luzz, I have no idea what you are asking... Can you be more specific?

isladogs · Apr 2, 2018

Set the default value of your textbox equal to that
OR use a label with that as a caption

luzz · Apr 2, 2018

ridders said:
Set the default value of your textbox equal to that
OR use a label with that as a caption

i tried using label with that as a caption but it does not allow any editing to be done to it, as i will need to edit some of the text

arnelgp · Apr 2, 2018

on each Textbox, Property->Default Value, put those values.

luzz · Apr 2, 2018

NauticalGent said:
Sorry Luzz, I have no idea what you are asking... Can you be more specific?

I am asking if it is possible to constantly show
1) Please State:
2) Shrinkage: Maximum W: L : Twist:
3) PP sample -

in the textbox on access form?

luzz · Apr 2, 2018

arnelgp said:
on each Textbox, Property->Default Value, put those values.

I encounter error "Too many close parenthesis"

bob fitz · Apr 2, 2018

luzz said:
I encounter error "Too many close parenthesis"

Use quotation mark at the start and end of the text.

Code:

[CODE]"1) Please State: 
2) Shrinkage: Maximum W: L : Twist:
3) PP sample -"

[/CODE]

arnelgp · Apr 2, 2018

Property->Data->Default Value:

"1) Please State: " & Chr(13) & Chr(10) & "2) Shrinkage: Maximum W: L : Twist: " & Chr(13) & Chr(10) & "3) PP sample - "

another option is on the Form's BeforeInsert Event:

Private Sub Form_BeforeInsert(Cancel As Integer)
Me.Remarks = "1) Please State: " & vbCrLf & _
"2) Shrinkage: Maximum W: L : Twist: " & vbCrLf & _
"3) PP sample - "
End Sub

isladogs · Apr 2, 2018

luzz said:
i tried using label with that as a caption but it does not allow any editing to be done to it, as i will need to edit some of the text

The idea of the label method is to place that next to your textbox!
The textbox is still needed for data entry.

Or use the default value property where the text is then overwritten by users when they enter data

arnelgp · Apr 3, 2018

im sorry Vanes, i forgot your form is Unbound. here is the fix (see Sub showRecord()).

arnelgp · Apr 4, 2018

please see the sample Luzz:

arnelgp · Apr 4, 2018

i made a form frmHidden on the sample db, you should import it to your working db.

test it first. let me know.

Automatically show remark comment in textbox (1 Viewer)

luzz

Registered User.

NauticalGent

Ignore List Poster Boy

isladogs

MVP / VIP

luzz

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

luzz

Registered User.

luzz

Registered User.

Attachments

bob fitz

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Similar threads

Users who are viewing this thread