Automatically show remark comment in textbox

[luzz]

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]

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

 

[isladogs]

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

 

[luzz]

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]

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

 

[luzz]

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]

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

I encounter error "Too many close parenthesis"

 

[bob fitz]

I encounter error "Too many close parenthesis"

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

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

[/CODE]

 

[arnelgp]

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]

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]

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

 

[arnelgp]

please see the sample Luzz:

 

[arnelgp]

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

test it first. let me know.