UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Editing Fields With Expression, Access 2013    
 
   
Quinto1
post Feb 22 2020, 12:28 PM
Post#1



Posts: 113
Joined: 23-April 16



Hi all,
Is it possible to edit fields in a form that is filled by an expression? or add additional comments?

Thank you
Go to the top of the page
 
cheekybuddha
post Feb 22 2020, 12:30 PM
Post#2


UtterAccess Moderator
Posts: 12,620
Joined: 6-December 03
From: Telegraph Hill


No

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post Feb 22 2020, 12:33 PM
Post#3


UtterAccess Moderator
Posts: 12,620
Joined: 6-December 03
From: Telegraph Hill


If the textbox is not on a continuous form you can populate it via code (ie it is unbound), perhaps in the form's Current event, or other control events, and use an AfterUpdate event to handle any user changes.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
theDBguy
post Feb 22 2020, 12:46 PM
Post#4


UA Moderator
Posts: 77,725
Joined: 19-June 07
From: SunnySandyEggo


What is the expression?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Quinto1
post Feb 22 2020, 02:02 PM
Post#5



Posts: 113
Joined: 23-April 16



IIf([Code]="vac", "Vacation")
I would like to be able to add additional comments on the same field
Go to the top of the page
 
theDBguy
post Feb 22 2020, 02:56 PM
Post#6


UA Moderator
Posts: 77,725
Joined: 19-June 07
From: SunnySandyEggo


Well, unfortunately, even if you were able to add more comments in the same Textbox, it won't be stored in your table. So, after you move to the next record, the comment you added is basically lost. The other thing that was previously mentioned, if you use an unbound Textbox on a Datasheet or Continuous Form, then those comments you add will display for all the rows on your Form, since it's not really assigned to any particular record.

One thing you could consider is simply add a Memo/Long Text field to your table and add your comments there. Just a thought...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Quinto1
post Feb 22 2020, 03:36 PM
Post#7



Posts: 113
Joined: 23-April 16



That would not work for the intended purpose.
Thank you, as alway I appreciate your feedback

Quinto
Go to the top of the page
 
projecttoday
post Feb 22 2020, 03:36 PM
Post#8


UtterAccess VIP
Posts: 11,802
Joined: 10-February 04
From: South Charleston, WV


You need a comments subtable.

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    4th April 2020 - 06:47 AM