How to write a mathematic equation in a table in Microsoft Access?

Asked Oct 29 '16 at 14:34

Active Oct 29 '16 at 14:43

Viewed 132 times

So I'm trying to write a mathematic equation in a table row in Microsoft Access , like

but even if I copy it from Microsoft Word(for example), it automatically converts it to

a^2+b^2=c^2

Any ideas ?

edited Oct 29 '16 at 14:43

asked Oct 29 '16 at 14:34

Vakho Akobia

In a MS access table row – Vakho Akobia Oct 29 '16 at 14:42
1

^ is the squared operator in Access. What is the data format of your field and what are you trying to achieve? A calculation, or just text? – Absinthe Oct 29 '16 at 14:45
I am writing a maths exam program in c#. The questions and its answers are written in MS Access database(I have QuestionsTable and AnswersTable) . In c# i just display the rows from the MS database tables. So i want the mathematic equations In MS database to be written in a proper form .I am writing a maths exam program in c#. The questions and its answers are written in MS Access database(I have QuestionsTable and AnswersTable) . In c# i just display the rows from the MS database tables. So i want the mathematic equations In MS database to be written in a proper form . – Vakho Akobia Oct 29 '16 at 15:33
The data format is text (Long Text) – Vakho Akobia Oct 29 '16 at 15:34
1

You are going to need a rich-text control, and store HTML in the database. Your example can be simulated with the ² character, but anything more complicated won't work with plain text. – Andre Oct 29 '16 at 20:05

0 Answers0